[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Experimental patch for inter-page delay in VACUUM
From:       "Matthew T. O'Connor" <matthew () zeut ! net>
Date:       2003-10-31 22:19:51
[Download RAW message or body]

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.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
[prev in list] [next in list] [prev in thread] [next in thread]