Re: scheduling autovacuum at lean hours only.

On Wed, Feb 11, 2009 at 2:57 PM, Rajesh Kumar Mallah
<mallah(dot)rajesh(at)gmail(dot)com> wrote:

>> vacuum_cost_delay = 150
>> vacuum_cost_page_hit = 1
>> vacuum_cost_page_miss = 10
>> vacuum_cost_page_dirty = 20
>> vacuum_cost_limit = 1000
>> autovacuum_vacuum_cost_delay = 300
>
> why is it not a good idea to give end users control over when they
> want to run it ?

Effectively, you have control over autovacuum via these params.
You have to remember, that autovacuum doesn't cost much, and it makes
planner know more about data.
It's not there to clean up databases, as you might imagine - it is
there to update stats, and mark pages as free.

So make sure you tweak that config fist, because I have a funny
feeling that you just think that vacuuming bogs down your machine, and
_can_ be turned off without any bad consequences, which is simply not
true.

--
GJ