Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group