Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: update from select
- From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: update from select
- Date: Mon, 29 Oct 2007 11:45:29 +0100
- Message-id: <20071029104529.GB16653@a-kretschmer.de> <text/plain>
am Mon, dem 29.10.2007, um 10:18:38 +0100 mailte dev(at)kbsolutions(dot)ch folgendes: > > WHERE table1.column1 = temp_table.column1; table1.column1 and temp_table.column1 have the same type? > > > > The select by it?s own takes around 1 second. The Update is around 120?000 > rows. I got an index on column1. The whole query needs around 16 minutes. Show us the EXPLAIN ANALYSE - result. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
- Follow-Ups:
- Re: update from select
- From: dev
- Re: update from select
- References:
- update from select
- From: dev
- update from select
- Prev by Date: update from select
- Next by Date: Re: update from select
- Previous by thread: update from select
- Next by thread: Re: update from select
- Indexes: