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

Re: Experimental patch for inter-page delay in VACUUM

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen <jleelim(at)xxxxxx(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-10-31 22:19:51
Message-ID: 3FA2E007.4040801@zeut.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:

>"Stephen" <jleelim(at)xxxxxx(dot)com> writes:
>  
>
>>Great! I haven't tried it yet, but I love the thought of it already :-)
>>I've been waiting for something like this for the past 2 years and now it's
>>going to make my multi-gigabyte PostgreSQL more usable and responsive. Will
>>the delay be tunable per VACUUM invocation?
>>    
>>
>
>As the patch is set up, you just do "SET vacuum_page_delay = n" and
>then VACUUM.
>  
>
probably a setting that autovacuum will tweak based on things like table 
size etc.... If we can find a way to automatically tweak it that makes 
sense.


In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-10-31 22:49:09
Subject: Re: out of date bufmgr README
Previous:From: Neil ConwayDate: 2003-10-31 22:15:55
Subject: out of date bufmgr README

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