Robert Treat wrote:
> On Tue, 2004-01-06 at 07:20, Shridhar Daithankar wrote:
>>The numbers from pg_class are estimates updated by vacuum /analyze. Of course
>>you need to run vacuum frequent enough for that statistics to be updated all
>>the time or run autovacuum daemon..
>>Ran into same problem on my machine till I remembered about vacuum..:-)
> Actually you only need to run analyze to update the statistics.
Old habits die hard..:-)
In response to
pgsql-performance by date
|Next:||From: Greg Stark||Date: 2004-01-06 18:12:17|
|Subject: Re: Inefficient SELECT with OFFSET and LIMIT|
|Previous:||From: Robert Treat||Date: 2004-01-06 16:03:23|
|Subject: Re: Select max(foo) and select count(*) optimization|