is it good to disable autovacuum and schedule routine vacuum process?

Поиск
Список
Период
Сортировка
От AI Rumman
Тема is it good to disable autovacuum and schedule routine vacuum process?
Дата
Msg-id AANLkTimbXP4i7K6sgqSE4kgzhdX-vPAmurfJPwhkdsBU@mail.gmail.com
обсуждение исходный текст
Ответы Re: is it good to disable autovacuum and schedule routine vacuum process?
Список pgsql-general
Дерево обсуждения
I am using Postgresql 9.0.1.
I want to know which one is good regarding  VACUUM - Routine VACUUM manualy or AutoVacuum.
Recently, I found in my production that  some tables were not vacuumed for a good period of time when the autovacuum was enabled and the DB was slow. I vacuumed the DB manually and the performance was good.
Can anyone explain why this was happened and is it good to disable autovacuum and schedule routine vacuum process?


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

Предыдущее
От: Konstantin Izmailov
Дата:
Сообщение: Re: pg_temp 101 question
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: is it good to disable autovacuum and schedule routine vacuum process?