From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
Date: Wed, 19 Jan 2011 12:26:56 -0500
Message-ID: <21792.1295458016@sss.pgh.pa.us> (raw)
In-Reply-To: <201101191110.05268.achill@matrix.gatewaynet.com>
References: <955263366.48014741295283147090.JavaMail.root@ucimail4.uci.cu>
<201101181006.03790.achill@matrix.gatewaynet.com>
<4D35A30D.4030404@vmsinfo.com>
<201101191110.05268.achill@matrix.gatewaynet.com>
Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> Anyway, i will repost the EXPLAIN plans by copying pasting the query, without the analyze part.
Please show EXPLAIN ANALYZE, not just EXPLAIN, results. When
complaining that the planner did the wrong thing, it's not very helpful
to see only its estimates and not reality.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, achill@matrix.gatewaynet.com
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
In-Reply-To: <21792.1295458016@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox