Maciek Sakrejda <msakrejda@xxxxxxxxxxx> wrote: > No NULLs. It looks like it's a good deal slower than the LOJ > version, but a good deal faster than the original. On 8.4 and later the NOT EXISTS I suggested is a bit faster than your fast version, since Tom did some very nice work in this area, implementing semi join and anti join. If you've got much load with this kind of query, it might be worth upgrading. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
