Remove autovacuum GUC?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Remove autovacuum GUC?
Дата
Msg-id 0fb95cdc-4409-9500-5752-f40bef96165c@commandprompt.com
обсуждение исходный текст
Ответы Re: Remove autovacuum GUC?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hello,

After all these years, we are still regularly running into people who 
say, "performance was bad so we disabled autovacuum". I am not talking 
about once in a while, it is often. I would like us to consider removing 
the autovacuum option. Here are a few reasons:

1. It does not hurt anyone
2. It removes a foot gun
3. Autovacuum is *not* optional, we shouldn't let it be
4. People could still disable it at the table level for those tables 
that do fall into the small window of, no maintenance is o.k.
5. People would still have the ability to decrease the max_workers to 1 
(although I could argue about that too).

Sincerely,

JD

-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: File content logging during execution of COPY queries (was: Better logging of COPY queries if log_statement='all')
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Disable autovacuum guc?