[ 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.tiwari@inventum.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