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 27295.1533132507@sss.pgh.pa.us
Whole thread Raw
In response to Template0 datfrozenxid age is 160million and progressing  (Rijo Roy <rjo_roy@yahoo.com>)
Responses Re: Template0 datfrozenxid age is 160million and progressing
List pgsql-general
Rijo Roy <rjo_roy@yahoo.com> writes:
> I am observing a steady increase in age(datfrozenxid) of template0 database in my Postgresql 10 running in a RHEL
6.9Currently,it is at 166846989 and I am not able to vacuum the same as datallowconn is false. Thought of setting it to
trueand perform a vacuum freeze on the same. Before doing that, I wanted to check whether I should be worrying for
somethinghere or can I just go ahead with my plan.  

I would leave well enough alone.  Unless you've changed the default
values of autovacuum parameters, that behavior is perfectly normal
and not worrisome.  autovacuum should kick in and do something
about it at 200 million xacts (autovacuum_freeze_max_age).

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Adding terminal title support for psqlrc
Next
From: Vick Khera
Date:
Subject: Re: Settings for fast restores