Re: Simple thing to make pg_autovacuum more useful - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple thing to make pg_autovacuum more useful
Date
Msg-id 15594.1200606887@sss.pgh.pa.us
Whole thread Raw
In response to Simple thing to make pg_autovacuum more useful  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Simple thing to make pg_autovacuum more useful  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Can we by default set vac_cost_limit and vac_cost_delay have a DEFAULT
> - -1? That way by default it will use the settings in postgresql.conf?

Surely we're not going to force initdb for that.

> Secondly can we set the default for freeze_min_age to 100mil (I think
> that is the default in the docs) and freeize_max_age to the default
> 200000000 .

This is an outright bad idea, because those defaults aren't hard-wired.
Why would you not use -1 if you want a default value?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Simple thing to make pg_autovacuum more useful
Next
From: "Kevin Grittner"
Date:
Subject: Re: Renaming a constraint's index