Re: stats are way off on 8.4 b1

From: Tom Lane
Subject: Re: stats are way off on 8.4 b1
Date: ,
Msg-id: 1193.1240010997@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz)
Responses: Re: stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz)
List: pgsql-performance

Tree view

stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz, )
 Re: stats are way off on 8.4 b1  (Tom Lane, )
  Re: stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz, )
   Re: stats are way off on 8.4 b1  (Heikki Linnakangas, )
    Re: stats are way off on 8.4 b1  (Grzegorz Jaśkiewicz, )

=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <> 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:

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