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.
First the details:
select version()
Thank you Tom..
Can you recommend any documentation that explains the process?
Keith Kreuzer
ext 3424
Tom Lane [EMAIL PROTECTED]
09/29/2008 10:00 AM
To
[EMAIL PROTECTED]
cc
pgsql-admin@postgresql.org
Subject
Re: [ADMIN] understand the process of ID wraparound
[EMAIL PROTECTED]
Hi
While running a VACUUM ANALYZE
The process aborts and I receive the following message in the log:
ERROR: could not open relation 16388/24734/51896: Cannot open or remove a
file containing a running program.
STATEMENT: VACUUM ANALYZE
51896 refers to an index on a table with over 10,000,000