Can you recommend any documentation that explains the process?
Keith Kreuzer ext 3424
Tom Lane <tgl@sss.pgh.pa.us>
09/29/2008 10:00 AM
To
KKreuzer@kbtoys.com
cc
pgsql-admin@postgresql.org
Subject
Re: [ADMIN] understand the process of ID wraparound
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.