Re: Autovacuum Issue

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Autovacuum Issue
Дата
Msg-id CA+TgmobPwvrHXgBYHPcY9jFpaTumGaMHi-vMTm5hFLVxircQGw@mail.gmail.com
обсуждение исходный текст
Ответ на Autovacuum Issue  (J Ramesh Kumar <rameshj1977@gmail.com>)
Ответы Re: Autovacuum Issue
Список pgsql-performance
On Wed, Nov 23, 2011 at 12:55 AM, J Ramesh Kumar <rameshj1977@gmail.com> wrote:
> Why the autovacuum is running even though, I disabled ? Am I miss anything ?

As Raghavendra says, anti-wraparound vacuum will always kick in to
prevent a database shutdown.

> And also please share your views on my decision about disable autovacuum for
> my application. I am planning to run vacuum command daily on that small
> table which has frequent updates.

Sounds like a bad plan.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: vacuum internals and performance affect
Следующее
От: MirrorX
Дата:
Сообщение: Re: vacuum internals and performance affect