| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Sachchida Ojha <sojha(at)secure-elements(dot)com> |
| Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Autovacuum is running forever |
| Date: | 2007-08-21 21:54:41 |
| Message-ID: | 20070821215441.GA12717@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Sachchida Ojha wrote:
> vacuum_cost_delay = 200
That is absurdly high. A setting of 10 is more likely to be useful.
> autovacuum_naptime = 3600
That is too high probably as well; particularly so if you have "updates
and deletes every second".
> #autovacuum_vacuum_scale_factor = 0.4
> #autovacuum_analyze_scale_factor = 0.2
These too. Try 0.1 for both and see how it goes.
In short, you need autovacuum to run _way more often_ than you are.
--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-08-21 22:01:23 | Re: Autovacuum is running forever |
| Previous Message | Sachchida Ojha | 2007-08-21 21:52:32 | Re: Autovacuum is running forever |