Re: Template0 datfrozenxid age is 160million and progressing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Template0 datfrozenxid age is 160million and progressing
Date: 2018-08-01 16:07:16
Message-ID: 9200.1533139636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andres Freund <andres(at)anarazel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-08-01 16:12:27 Re: Template0 datfrozenxid age is 160million and progressing
Previous Message Andres Freund 2018-08-01 15:39:37 Re: Template0 datfrozenxid age is 160million and progressing