On Mon, Aug 02, 2010 at 01:35:13PM -0700, Maciek Sakrejda wrote: > >> All fields involved are declared NOT NULL, but thanks for the heads up. > >Afair the planner doesnt use that atm. > > I was referring to not having to care about the strange NULL semantics > (as per your original comment), since I have no NULLs. Given that, I > think the NOT EXISTS could be a good solution, even on 8.3 (we're > planning to upgrade, but it's not a feasible solution to this > particular problem), no? The point is that only 8.4 will optimize that case properly. 8.3 will generate plans which are inefficient in many (or most) cases for both variants. I would suggest to use manual antijoins... -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
