"D'Arcy J.M. Cain" <darcy(at)druid(dot)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