Re: [GENERAL] continuous copy/update one table to another

[Tom Lane]

Szymon Guz <mabew...@gmail.com> writes:
> W dniu 1 marca 2010 09:40 użytkownik Grzegorz Jaśkiewicz
> <gryz...@gmail.com>napisał:
>> don't use 'NOT EXISTS', as this will be damn slow. Use LEFT JOIN.

> Right, LEFT JOIN should be faster (with proper indices even much faster).

Converting NOT EXISTS into an outer join is a manual application of an
optimization that Postgres can do for itself in 8.4 and up.  So the
above advice should only be correct for 8.3 or before.

                        regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general