Re: controlling autovacuum during the day.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: controlling autovacuum during the day.
Дата
Msg-id 28510.1229525243@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: controlling autovacuum during the day.  ("John Lister" <john.lister-ps@kickstone.com>)
Ответы Re: controlling autovacuum during the day.  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-admin
"John Lister" <john.lister-ps@kickstone.com> writes:
> Cheers for the quick reply. I've tweaked them quite a bit, but we have quite
> a few heavily updated tables that i'd like vacuuming to keep them in check.
> Unfortunately the autovacuum does a FULL vacuum every so often locking the
> tables for quite a long time, i'd like to move these to the evening if
> possible.

Huh?  Autovacuum *never* does VACUUM FULL.

            regards, tom lane

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

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