Re: Vacuum, Freeze and Analyze: the big picture - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Vacuum, Freeze and Analyze: the big picture
Date
Msg-id CAMkU=1w5U27WSyXN9NLJs5j6FyLQGZnRV0xL6FFAnaOxsrTx9w@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum, Freeze and Analyze: the big picture  (Craig Ringer <craig@2ndquadrant.com>)
List 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 by date:

Previous
From: Christian Ullrich
Date:
Subject: Re: Hard limit on WAL space used (because PANIC sucks)
Next
From: Andres Freund
Date:
Subject: Re: Hard limit on WAL space used (because PANIC sucks)