Re: not exits slow compared to not in. (nested loops killing me) - Mailing list pgsql-performance

From Tom Lane
Subject Re: not exits slow compared to not in. (nested loops killing me)
Date
Msg-id 16102.1307405380@sss.pgh.pa.us
Whole thread Raw
In response to Re: not exits slow compared to not in. (nested loops killing me)  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
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=159c47dc7170110a39f8a16b1d0b7811f5556f87

            regards, tom lane

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: not exits slow compared to not in. (nested loops killing me)
Next
From: "mark"
Date:
Subject: Re: not exits slow compared to not in. (nested loops killing me)