On Mon, 29 Sep 2003, Tom Lane wrote: > 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.
For the sort+seq one and the not exists, I had, but I'll re-run it (it's on my home desktop that I won't be able to access). The other when I forced it to use an index scan I haven't let complete yet, and I don't know how long that will take. I was also planning to run a set after running analyze, so I'll include those too. It'll probably be a few hours before the results are in. :) Are there any other options (enable_mergejoin, etc) that you want me to try with? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly