Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: eleinDate: 2003-10-31 20:55:12
Subject: Re: Annotated release notes
Previous:From: Bruce MomjianDate: 2003-10-31 20:40:18
Subject: Re: static pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group