>>> 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. I'll give it a shot. I've never had the patience to let the one with the cost five or six orders of magnitude higher than the others run to completion, but I've started the lot of 'em. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
