| 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: | Whole Thread | Raw Message | 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 |