Thread: age(datfrozenxid)

age(datfrozenxid)

From
Date:

can anyone please tell  what does
 SELECT age(datfrozenxid)  from pg_database

signify and why it keeps increasing monotonically ?


regds
mallah.


-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



Re: age(datfrozenxid)

From
Tom Lane
Date:
<mallah@trade-india.com> writes:
> can anyone please tell  what does
>  SELECT age(datfrozenxid)  from pg_database
> signify and why it keeps increasing monotonically ?

Basically it measures the time since you last vacuumed each database.
See the Admin Guide:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

            regards, tom lane