Re: Experimental patch for inter-page delay in VACUUM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Experimental patch for inter-page delay in VACUUM
Date
Msg-id 19653.1067633656@sss.pgh.pa.us
Whole thread Raw
In response to Re: Experimental patch for inter-page delay in VACUUM  (Christopher Browne <cbbrowne@libertyrms.info>)
List 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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: static pg_dump
Next
From: Larry Rosenman
Date:
Subject: Regression Failure: CURRENT SOURCES/union&join