Horton

Re: Select max(foo) and select count(*) optimization

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To:
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Date: 2004-01-06T16:31:20Z
Lists: pgsql-performance 
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..:-)

  shridhar