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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpLfM5OHZFng.pgp
Description: PGP signature
