age(datfrozenxid) negative for template0. Is this normal?

Started by Denis Gasparinalmost 20 years ago2 messagesgeneral
Jump to latest
#1Denis Gasparin
denis@edistar.com

Today I executed the following query as stated into the Administrator
Guide to check the XID wraparound problem:

SELECT datname, age(datfrozenxid) FROM pg_database;

All the database report an age of 1 billion except for the template0
database. This is an extract of the result of the query:

datname | age
-------------------------+------------
template1 | 1073794149
template0 | -686262347

Is it normal that the age for template0 is negative?

The version of the backend is 7.4.6 with pg_autovacuum running.

Please let me know as soon as possible if this is a problem or not...

Thank you,
Denis

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Denis Gasparin (#1)
Re: age(datfrozenxid) negative for template0. Is this normal?

Denis Gasparin <denis@edistar.com> writes:

Is it normal that the age for template0 is negative?

template0 doesn't require vacuuming, so it doesn't matter what age it
shows.

regards, tom lane