Horton

Re: Experimental patch for inter-page delay in VACUUM

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: "Matthew T. O'Connor" <matthew@zeut.net>, pgsql-hackers@postgresql.org
Date: 2003-10-31T17:05:06Z
Lists: pgsql-hackers 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> What is the advantage of delaying vacuum per page vs. just doing vacuum
> less frequently?

The point is the amount of load VACUUM poses while it's running.  If
your setup doesn't have a lot of disk bandwidth to spare, a background
VACUUM can hurt the performance of your foreground applications quite
a bit.  Running it less often doesn't improve this issue at all.

			regards, tom lane