Horton

Re: Still recommending daily vacuum...

Decibel! <decibel@decibel.org>

View thread View on postgr.es
From: "Jim C. Nasby" <decibel@decibel.org>
To: Michael Paesold <mpaesold@gmx.at>
Cc: "Joshua D. Drake" <jd@commandprompt.com>, Alvaro Herrera <alvherre@commandprompt.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2007-07-03T20:09:41Z
Lists: pgsql-hackers 
On Tue, Jul 03, 2007 at 11:31:08AM +0200, Michael Paesold wrote:
> Joshua D. Drake wrote:
> >Alvaro Herrera wrote:
> >>Joshua D. Drake wrote:
> >>>Did we change the default autovac parameters for 8.3 (beyond turning 
> >>>it on?) because on any reasonably used database, they are way to 
> >>>conservative.
> >>
> >>We're still on time to change them ...  Any concrete proposals?
> >
> >I could provide numbers from production high use databases. We could 
> >probably back those down a little and make more reasonable numbers.
> 
> Please do so. Perhaps others can also tell their typical settings.

FWIW, I normally go with the 8.2 defaults, though I could see dropping
vacuum_scale_factor down to 0.1 or 0.15. I also think the thresholds
could be decreased further, maybe divide by 10.
-- 
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)