Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> As an update, so far I still am getting better results with NOT EXISTS
> than the left join.

Hm.  Don't suppose you were using EXPLAIN ANALYZE so we could see what's
happening?  This is clearly a planner failure, although I'm unsure if we
can expect the planner to get the right answer with no pg_statistic entries.
        regards, tom lane