Re: Template0 datfrozenxid age is 160million and progressing - Mailing list pgsql-general

From Tom Lane
Subject Re: Template0 datfrozenxid age is 160million and progressing
Date
Msg-id 9200.1533139636@sss.pgh.pa.us
Whole thread Raw
In response to Re: Template0 datfrozenxid age is 160million and progressing  (Andres Freund <andres@anarazel.de>)
Responses Re: Template0 datfrozenxid age is 160million and progressing
List pgsql-general
Andres Freund <andres@anarazel.de> writes:
> On 2018-08-01 10:24:24 -0400, Tom Lane wrote:
>> IMO, the action you need to take is enabling autovacuum.  We've
>> seen many many people go down the path you are taking, and it's
>> generally led to no good in the end.  Manual vacuuming tends
>> to miss stuff, and it cannot react adequately to activity spikes.

> But it shouldn't matter here, autovacuum will start regardless, no?

Sure, once it decides that emergency anti-wraparound vacuuming is
necessary.  I really doubt the OP wants that to happen; it's the
exact opposite of non-intrusive.

            regards, tom lane


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Template0 datfrozenxid age is 160million and progressing
Next
From: Andres Freund
Date:
Subject: Re: Template0 datfrozenxid age is 160million and progressing