Re: Simple thing to make pg_autovacuum more useful

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Simple thing to make pg_autovacuum more useful
Дата
Msg-id 15594.1200606887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Simple thing to make pg_autovacuum more useful  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Simple thing to make pg_autovacuum more useful  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Simple thing to make pg_autovacuum more useful
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Renaming a constraint's index