From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Brendan Duddridge <brendan(at)clickspace(dot)com> |
Cc: | Luke Lonergan <llonergan(at)greenplum(dot)com>, Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: count(*) performance |
Date: | 2006-03-27 19:35:28 |
Message-ID: | 20060327193527.GB12691@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Guido Neitzer | 2006-03-27 19:43:43 | Re: count(*) performance |
Previous Message | Matthew T. O'Connor | 2006-03-27 19:21:38 | Re: count(*) performance |