From: Tom Lane <tgl@sss.pgh.pa.us>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: mark <dvlhntr@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: not exits slow compared to not in. (nested loops killing me)
Date: Mon, 06 Jun 2011 20:09:40 -0400
Message-ID: <16102.1307405380@sss.pgh.pa.us> (raw)
In-Reply-To: <4DED5DB5.4030309@postnewspapers.com.au>
References: <BANLkTinjCKm3kC4GemetBmvOcwL5HBwqww@mail.gmail.com>
<4DED5DB5.4030309@postnewspapers.com.au>
Craig Ringer <craig@postnewspapers.com.au> writes:
> On 06/07/2011 04:38 AM, mark wrote:
> Hash Anti Join (cost=443572.19..790776.84 rows=1 width=1560)
> (actual time=16337.711..50358.487 rows=2196299 loops=1)
> Note the estimated vs actual rows. Either your stats are completely
> ridiculous, or the planner is confused.
The latter ... I think the OP is hurting for lack of this 9.0.4 fix:
http://git.postgresql.org/gitweb?p=postgresql.git&a=commitdiff&h=159c47dc7170110a39f8a16b1d0...
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, craig@postnewspapers.com.au, dvlhntr@gmail.com
Subject: Re: not exits slow compared to not in. (nested loops killing me)
In-Reply-To: <16102.1307405380@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