Scott Carey <scott@xxxxxxxxxxxxxxxxx> wrote: > Often, the best query plans result from 'LEFT JOIN WHERE right > side is NULL' rather than NOT EXISTS however. I often get > performance gains by switching NOT EXISTS queries to LEFT JOIN > form. Even in 8.4 and later? I would think that the anti-join that Tom added in 8.4 would always perform at least as well as the LEFT JOIN technique you describe. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
