From: Craig Ringer <craig@postnewspapers.com.au>
To: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
Date: Mon, 16 May 2011 19:06:27 +0800
Message-ID: <4DD10533.7050904@postnewspapers.com.au> (raw)
In-Reply-To: <BANLkTimo9PG9r+pP-wxT=Amk79G_UmtCwg@mail.gmail.com>
References: <BANLkTimo9PG9r+pP-wxT=Amk79G_UmtCwg@mail.gmail.com>
On 05/16/2011 06:05 PM, Jasmin Dizdarevic wrote:
> Hi,
>
> is there a reason why Not IN-performance is so poor in 9.0.4 compared to
> 8.4?
Example queries?
EXPLAIN ANALYZE output?
http://wiki.postgresql.org/wiki/SlowQueryQuestions
--
Craig Ringer
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-sql@postgresql.org
Cc: craig@postnewspapers.com.au, jasmin.dizdarevic@gmail.com
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
In-Reply-To: <4DD10533.7050904@postnewspapers.com.au>
* 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