Szymon Guz <mabewlun@xxxxxxxxx> writes: > W dniu 1 marca 2010 09:40 użytkownik Grzegorz JaÅ?kiewicz > <gryzman@xxxxxxxxx>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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general