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

From Tom Lane
Subject Re: Experimental patch for inter-page delay in VACUUM
Date
Msg-id 6254.1067627221@sss.pgh.pa.us
Whole thread Raw
In response to Re: Experimental patch for inter-page delay in VACUUM  ("Stephen" <jleelim@xxxxxx.com>)
Responses Re: Experimental patch for inter-page delay in VACUUM
List pgsql-hackers
"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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michele Bendazzoli
Date:
Subject: Re: 7.4 and 7.3.5 showstopper (was: Re: [SQL] Bug in Rule+Foreing
Next
From: Bruce Momjian
Date:
Subject: Re: Annotated release notes