>>> On Mon, Aug 4, 2008 at 6:48 PM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: >> I'm adding some NOT EXISTS examples to the thread for completeness of >> what someone might want to address while working on it. For two >> queries which can easily be shown (to a human viewer, anyway) to >> return identical results, I see performance differences of over five >> orders of magnitude. > > Could we see EXPLAIN ANALYZE not just EXPLAIN for these? When people > are complaining of bad planner behavior, I don't find bare EXPLAIN > output to be very convincing. The other five queries have a cost to millisecond ratio of between 9.8 and 267. If the expensive one falls in the same range, it will run for 2.3 to 64 years. I know I have left it running for days before without completion. I don't think I can devote the resources to it. Attached are the EXPLAIN ANALYZE output for the other five. -Kevin
not-exists-timings2.out
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
