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

[Shridhar Daithankar]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster