| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | andrew(at)supernews(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Autovacuum to-do list |
| Date: | 2005-08-02 02:22:14 |
| Message-ID: | 42EED8D6.6050000@zeut.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andrew - Supernews wrote:
>On 2005-08-01, "Matthew T. O'Connor" <matthew(at)zeut(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff MacDonald | 2005-08-02 02:35:00 | Re: Autovacuum to-do list |
| Previous Message | Andrew - Supernews | 2005-08-01 22:34:21 | Re: Autovacuum to-do list |