[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] age(datfrozenxid) negative for template0. Is this normal?
From:       Denis Gasparin <denis () edistar ! com>
Date:       2006-05-02 19:48:09
Message-ID: 4457B779.70002 () edistar ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
[prev in list] [next in list] [prev in thread] [next in thread]