2009/12/18 Robert Haas <[email protected]>: > 2009/12/18 Grzegorz Jaśkiewicz <[email protected]>: >> On Fri, Dec 18, 2009 at 2:18 PM, Robert Haas <[email protected]> wrote: >> >>> NOT IN is the only that really kills you as far as optimization is >>> concerned. IN can be transformed to a join. NOT IN forces a NOT >>> (subplan)-type plan, which bites - hard. >> >> in a well designed database (read: not abusing NULLs) - it can be done >> with joins too. > > But not by PostgreSQL, or so I believe.
using left join ? -- GJ -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
