Stephan Szabo <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings