[ 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@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
