Re: count(*) performance - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: count(*) performance
Date
Msg-id 20060327193527.GB12691@surnet.cl
Whole thread Raw
In response to Re: count(*) performance  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-performance
Brendan Duddridge wrote:
> Does that mean that even though autovacuum is turned on, you still
> should do a regular vacuum analyze periodically?

No, it probably means you have set FSM settings too low, or not tuned
the autovacuum parameters to your specific situation.

A bug in the autovacuum daemon is not unexpected however, so if it
doesn't work after tuning, let us know.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: count(*) performance
Next
From: Guido Neitzer
Date:
Subject: Re: count(*) performance