Postgres Pro
Downloads
Home   >   mailing lists

Re: update from select - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: update from select
Date
Msg-id 20071029104529.GB16653@a-kretschmer.de
Whole thread Raw
In response to update from select  (<dev@kbsolutions.ch>)
Responses Re: update from select
List pgsql-sql
Tree view 
am  Mon, dem 29.10.2007, um 10:18:38 +0100 mailte dev@kbsolutions.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

pgsql-sql by date:

Previous
From:
Date:
Subject: update from select
Next
From: "Pavel Stehule"
Date:
Subject: Re: update from select