Re: Still recommending daily vacuum...

Jim C. Nasby wrote:
> 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.

How about pushing thresholds all the way down to 0?

--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Vivir y dejar de vivir son soluciones imaginarias.
La existencia está en otra parte" (Andre Breton)