Horton

Re: Experimental patch for inter-page delay in VACUUM

Matthew T. O'Connor <matthew@zeut.net>

View thread View on postgr.es
From: "Matthew T. O'Connor" <matthew@zeut.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephen <jleelim@xxxxxx.com>, pgsql-hackers@postgresql.org
Date: 2003-10-31T22:19:51Z
Lists: pgsql-hackers 
Tom Lane wrote:

>"Stephen" <jleelim@xxxxxx.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.