Re: Nice vacuums - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Nice vacuums
Date
Msg-id 7715.1098461180@sss.pgh.pa.us
Whole thread Raw
In response to Nice vacuums  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: Nice vacuums
List pgsql-hackers
"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> I have an idea for a change to the contributed module pg_autovacuum that
> I would like to run by people.  What I want to do is make sure that when
> vacuum (or analyze) runs that it takes no time from actual transactions.
>  To this end I want to add an option (-n?) which runs nice(2) on the
> process ID of the backend.

Please re-read all the previous threads on the uselessness of nice.

What *would* be useful is an option to turn on the 8.0 vacuum cost delay
features (ie, set non-default values for those GUC variables).
        regards, tom lane


pgsql-hackers by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Nice vacuums
Next
From: Jan Wieck
Date:
Subject: Re: [Slony1-general] Re: [GENERAL] Slony-I 1.0.4 Released