Re: understand the process of ID wraparound - Mailing list pgsql-admin

From Tom Lane
Subject Re: understand the process of ID wraparound
Date
Msg-id 11364.1222696819@sss.pgh.pa.us
Whole thread Raw
In response to understand the process of ID wraparound  (KKreuzer@kbtoys.com)
Responses Re: understand the process of ID wraparound
List pgsql-admin
KKreuzer@kbtoys.com writes:
> I am hoping someone can help a novice understand the process of ID
> wraparound, I have read many of the articles
> on the web but don't understand why my age(datfrozenxid) never gets reset.
> I am not sure if I even have a
> problem, just trying to be proactive.

You don't have a problem.  The datfrozenxid values you are showing are
around 31 million transactions.  Nothing is going to happen until they
exceed vacuum_freeze_min_age, which is 100 million transactions.

            regards, tom lane

pgsql-admin by date:

Previous
From: KKreuzer@kbtoys.com
Date:
Subject: understand the process of ID wraparound
Next
From: KKreuzer@kbtoys.com
Date:
Subject: Re: understand the process of ID wraparound