"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.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
