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) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq