Re: What's the XID?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "ivan(dot)hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What's the XID?
Date: 2008-01-02 05:32:29
Message-ID: 9801.1199251949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"ivan.hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net> writes:
> step 1. SELECT datname, age(datfrozenxid) FROM pg_database;
> --> mydb age:33183
> step 2. SELECT datname, age(datfrozenxid) FROM pg_database;
> --> mydb age:33188

> why always increased by 5?

If you do it directly in psql, it increases by 1.

> Postgresql Ver:8.1.3
> using pgAdminIII Query window

Perhaps you should ask the pgAdmin people what they're doing behind your
back ...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2008-01-02 08:37:11 Re: What's the XID?
Previous Message ivan.hou 2008-01-02 04:52:02 Re: What's the XID?