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

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