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

From: Denis Gasparin <denis(at)edistar(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: age(datfrozenxid) negative for template0. Is this normal?
Date: 2006-05-02 19:48:09
Message-ID: 4457B779.70002@edistar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-02 20:17:18 Re: 8.1.4 anytime soon?
Previous Message Martijn van Oosterhout 2006-05-02 19:21:37 Re: Calling V1 function from within the server