Re: controlling autovacuum during the day.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: controlling autovacuum during the day.
Дата
Msg-id 27759.1229521625@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: controlling autovacuum during the day.  ("John Lister" <john.lister-ps@kickstone.com>)
Ответы Re: controlling autovacuum during the day.  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
Список pgsql-admin
"John Lister" <john.lister-ps@kickstone.com> writes:
> I'd like to use autovacuum to clean up the tables rather than schedule a
> full vacuum with cron as it will be more selective/intelligent about what
> gets cleaned. But is it possible to stop it running during peak/office
> hours?

No.  Instead, set the vacuum cost parameters to make it run slow enough
to not interfere too much with your work.

            regards, tom lane

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

Предыдущее
От: "John Lister"
Дата:
Сообщение: Re: controlling autovacuum during the day.
Следующее
От: "John Lister"
Дата:
Сообщение: Re: controlling autovacuum during the day.