Re: Vacuum, Freeze and Analyze: the big picture

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Vacuum, Freeze and Analyze: the big picture
Дата
Msg-id CAMkU=1w5U27WSyXN9NLJs5j6FyLQGZnRV0xL6FFAnaOxsrTx9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum, Freeze and Analyze: the big picture  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Jun 3, 2013 at 5:03 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
->
"I'll whack in some manual VACUUM cron jobs during low load maintenance
hours and hope that keeps the worst of the problem away, that's what
random forum posts on the Internet say to do".
-> "oh my, why did my DB just do an emergency shutdown?"


This one doesn't make much sense to me, unless they mucked around with autovacuum_freeze_max_age as well as turning autovacuum itself off (common practice?).  With the default setting of autovacuum_freeze_max_age, if it can't complete the anti-wraparound before emergency shutdown with autovac off, it probably would not have completed it with autovac on, either.

Cheers,

Jeff

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

Предыдущее
От: Christian Ullrich
Дата:
Сообщение: Re: Hard limit on WAL space used (because PANIC sucks)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Hard limit on WAL space used (because PANIC sucks)