Re: Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database.

[ removing -jobs from cc list as it is not appropriate for this posting ]

On Thu, Nov 12, 2009 at 3:18 AM, Brahma Prakash Tiwari
<brahma(dot)tiwari(at)inventum(dot)cc> wrote:
> Hi all
>
> Why age (datfrozenxid) in postgres becomes 1073742202 not zero after vacuum
> of database.
>
> Thanks in advance

I think you're misunderstanding the meaning of the column. As the
fine manual explains:

"Similarly, the datfrozenxid column of a database's pg_database row is
a lower bound on the normal XIDs appearing in that database — it is
just the minimum of the per-table relfrozenxid values within the
database."

http://www.postgresql.org/docs/current/static/routine-vacuuming.html

...Robert