Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
