Proposal- GUC for max dead rows before autovacuum

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Proposal- GUC for max dead rows before autovacuum
Дата
Msg-id CAHOFxGqM1MeUv7aSKZo9MNXwNpa6SwXgRnzpLky3VzvJY3yixA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Proposal- GUC for max dead rows before autovacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
Дерево обсуждения
To mitigate the need for per-table tuning of autovacuum configuration, I'd like to propose a new GUC for autovacuum_vacuum_threshold_max.

Currently, it seems that I can either set autovacuum_vacuum_scale_factor much smaller than default on tables with millions of rows, or set a value globally that means small tables are auto vacuumed rarely.

The default value for this new setting value could be -1 or 0 to disable the feature, or something like 100,000 perhaps so that tables with more than 500,0000 tuples are candidates for an autovacuum before they would with current default values.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Invisible PROMPT2
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: checkpointer: PANIC: could not fsync file: No such file ordirectory