Re: Autovacuum to-do list

On 2005-08-01, "Matthew T. O'Connor" <matthew@zeut.net> wrote:
>>* Stop a running VACUUM if the system load is too high.
>
> What if vacuum used a vacuum delay that was equal to the vacuum delay 
> GUC  settings * the system load.   Or something more sophisticated but 
> this would have the effect of having vacuum automatically throttle down 
> when the system gets busy and throttle back up when the system gets 
> quiet.  We would probably set some min / max values but it sounds 
> interesting, thoughts?

I'd be very concerned about feedback loop stability; insufficient
vacuuming can increase the system load, causing vacuum to get further
behind...

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services