Re: stats are way off on 8.4 b1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: stats are way off on 8.4 b1
Date: 2009-04-17 23:29:57
Message-ID: 1193.1240010997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman(at)gmail(dot)com> writes:
> That expected 1510 rows in 'assigments' seems to be pretty off,

The planner does not trust an empty table to stay empty. Every
Postgres version in living memory has acted like that; it's not
new to 8.4.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-04-17 23:34:23 Re: stats are way off on 8.4 b1
Previous Message Grzegorz Jaśkiewicz 2009-04-17 23:12:49 stats are way off on 8.4 b1