Re: serious issue with age(relfrozenxid)::int. - Mailing list pgsql-general

From Tom Lane
Subject Re: serious issue with age(relfrozenxid)::int.
Date
Msg-id 6699.1405870106@sss.pgh.pa.us
Whole thread Raw
In response to serious issue with age(relfrozenxid)::int.  (Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>)
List pgsql-general
Prabhjot Sheena <prabhjot.sheena@rivalwatch.com> writes:
>           Most of my tables in postgresql database 8.3 is showing up this.
> Pls suggest me what should be done with this and if this is something
> really serious

There's no reason to think that this means anything at all.  You did not
bother to filter by relkind, so most likely those MAXINT results
correspond to entries that have relfrozenxid = 0 because the system
doesn't track relfrozenxid for them (eg, indexes).

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: serious issue with age(relfrozenxid)::int.
Next
From: Tom Lane
Date:
Subject: Re: check database integrity