Re: age(datfrozenxid)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mallah(at)trade-india(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: age(datfrozenxid)
Date: 2003-06-10 19:24:18
Message-ID: 4170.1055273058@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<mallah(at)trade-india(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-06-10 19:29:18 Re: viewing the original (chrnological) order of entered
Previous Message Bruce Momjian 2003-06-10 19:09:45 Re: [GENERAL] MySQL gets $19.5 MM