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/
<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