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

Re: Experimental patch for inter-page delay in VACUUM

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-11-03 01:08:18
Message-ID: 3FA5AA82.60800@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> Attached is an extremely crude prototype patch for making VACUUM delay
> by a configurable amount between pages, in hopes of throttling its disk
> bandwidth consumption.  By default, there is no delay (so no change in
> behavior).  In some quick testing, setting vacuum_page_delay to 10
> (milliseconds) seemed to greatly reduce a background VACUUM's impact
> on pgbench timing on an underpowered machine.  Of course, it also makes
> VACUUM a lot slower, but that's probably not a serious concern for
> background VACUUMs.


[SNIP]

> The patch is against CVS tip, but should apply cleanly to any recent
> 7.4 beta.  You could likely adapt it to 7.3 without much effort.

Will we have this on 7.4 ?
I tried it and improve a lot the responsiness of my queries just putting
the delay equal to 10 ms.


Regards
Gaetano Mendola


In response to

pgsql-hackers by date

Next:From: Joe ConwayDate: 2003-11-03 03:32:57
Subject: Re: pgsql crosstab function
Previous:From: Christopher BrowneDate: 2003-11-03 00:15:07
Subject: Re: Experimental patch for inter-page delay in VACUUM

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