Re: not exits slow compared to not in. (nested loops killing me)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: mark <dvlhntr(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: not exits slow compared to not in. (nested loops killing me)
Date: 2011-06-07 00:09:40
Message-ID: 16102.1307405380@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig Ringer <craig(at)postnewspapers(dot)com(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mark 2011-06-07 00:16:12 Re: not exits slow compared to not in. (nested loops killing me)
Previous Message Craig Ringer 2011-06-06 23:07:33 Re: not exits slow compared to not in. (nested loops killing me)