Re: Experimental patch for inter-page delay in VACUUM

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christopher Browne <cbbrowne@libertyrms.info>
Cc: pgsql-hackers@postgresql.org
Date: 2003-10-31T20:54:16Z
Lists: pgsql-hackers
Christopher Browne <cbbrowne@libertyrms.info> writes:
> The advantage of the per-page delay is that performance is not being
> "totally hammered" by the vacuum.  If things are so busy that it's an
> issue, the system is liable to "limp somewhat," but that's not as bad
> as what we see now, where VACUUM and other activity are 'dueling' for
> access to I/O.  Per-page delay means that VACUUM mostly defers to the
> other activity, limiting how badly it hurts other performance.

... or that's the theory, anyway.  The point of putting up this patch
is for people to experiment to find out if it really helps.

			regards, tom lane