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

2006-05-02 Thread Denis Gasparin
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:

Re: [GENERAL] age(datfrozenxid) negative for template0. Is this normal?

2006-05-02 Thread Tom Lane
Denis Gasparin [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 9: