Re: slow update - Mailing list pgsql-general

On Fri, Jul 26, 2002 at 03:14:37PM +0200, Janning Vygen wrote:
>
> UPDATE real
>    SET val1=(SELECT val1 FROM temp WHERE temp.id = real.id ),
>        val2=(SELECT val2 FROM temp WHERE temp.id = real.id )
> WHERE  id IN (SELECT temp.id FROM temp);

Ick.  IN is a well-known dog in Postgres.  Try this:

UPDATE real
    SET val1=temp.val1,val2=temp.val2
    WHERE id=temp.id;

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110