Re: Experimental patch for inter-page delay in VACUUM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Browne <cbbrowne(at)libertyrms(dot)info>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-10-31 20:54:16
Message-ID: 19653.1067633656@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Browne <cbbrowne(at)libertyrms(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message elein 2003-10-31 20:55:12 Re: Annotated release notes
Previous Message Bruce Momjian 2003-10-31 20:40:18 Re: static pg_dump