Tom Lane wrote:

"Stephen" <[EMAIL PROTECTED]> 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

Reply via email to