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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
