Re: Experimental patch for inter-page delay in VACUUM - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Experimental patch for inter-page delay in VACUUM
Date
Msg-id 3FA2E007.4040801@zeut.net
Whole thread Raw
In response to Re: Experimental patch for inter-page delay in VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: out of date bufmgr README
Next
From: Tom Lane
Date:
Subject: Re: out of date bufmgr README