Re: Autovacuum on by default?

Matthew T. O'Connor wrote:
> That seems a big jump. BTW, I know .08 and .04 were suggested, but I
> didn't see confirmation that it was a good idea. I know my initial
> values were grossly over-conservative, but I am concerned about
> bogging down the server with lots of vacuums, especially since we
> don't have the delay settings on by default, nor do we have a
> maintenance windows yet.

OK, it seems that while everyone wants autovacuum be more aggressive by
default, no one has any good data to support one setting or another. I
so I suggest that we just cut scale factor and base threshold in half
right now (so it'd be 0.2, 0.1, 500, 250) and see about a
better-researched setting for the next release.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/