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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org