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

From David Rowley
Subject Re: Template0 datfrozenxid age is 160million and progressing
Date
Msg-id CAKJS1f9n9Lf5=P-BuD1QUDGvtEN=VdZxo7O3CJcCa1tfrqedOg@mail.gmail.com
Whole thread Raw
In response to Re: Template0 datfrozenxid age is 160million and progressing  (Rijo Roy <rjo_roy@yahoo.com>)
List pgsql-general
On 2 August 2018 at 02:31, Rijo Roy <rjo_roy@yahoo.com> wrote:
> I agree.. But unfortunately it is the business call and we cannot alter it..
> I am planning to convince them by keeping autovacuum_analyze_threshold to a
> high value so that auto analyse will not kick in very often leaving the
> autovacuum to do its job..
> Please advise.

If autovacuum is disabled, it'll still kick in for any anti-wraparound
work that needs to be performed.

This is also mentioned in the docs:

"Note that even when this parameter is disabled, the system will
launch autovacuum processes if necessary to prevent transaction ID
wraparound. See Section 24.1.5 for more information."

https://www.postgresql.org/docs/10/static/runtime-config-autovacuum.html

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Weird behaviour of the planner
Next
From: Achilleas Mantzios
Date:
Subject: Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .