| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How good is the default values for autovacuum? |
| Date: | 2009-01-15 23:16:54 |
| Message-ID: | dcc563d10901151516j4c6930d6r229fa2bb97135b4a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 15, 2009 at 3:49 PM, Bjørn T Johansen <btj(at)havleik(dot)no> wrote:
> Just wondering if I need to change the defalt values for autovacuum in version 8.3.5?
They're fairly good. A good way to see if it's working for you is to
let autovacuum run for a few days with your server handling a normal
load, and every night at midnight or so send yourself the last 15 or
so lines of output from vacuum verbose on your database(s).
If it keeps telling you to increase your free space map then either
autovacuum isn't aggresive enough, or your usage pattern simply
requires a larger FSM to keep things from bloating.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-01-15 23:23:45 | Re: Autovacuum daemon terminated by signal 11 |
| Previous Message | pepone.onrez | 2009-01-15 23:11:24 | Re: Initial ugly reverse-translator |