Re: Autovacuum to-do list

Andrew - Supernews wrote:

>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...
>

Right which is why we would need to enforce some max value so that 
vacuuming will never be totally squeezed out.