Postgres Pro
Downloads
Home   >   mailing lists

Re: stats are way off on 8.4 b1 - Mailing list pgsql-performance

From Tom Lane
Subject Re: stats are way off on 8.4 b1
Date
Msg-id 1193.1240010997@sss.pgh.pa.us
Whole thread Raw
In response to stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Tree view 
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.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

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: stats are way off on 8.4 b1
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: stats are way off on 8.4 b1