What's the XID?

From: "ivan(dot)hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: What's the XID?
Date: 2007-12-27 01:48:14
Message-ID: 14508639.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


http://www.postgresql.org/docs/8.1/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND

XID is transcation ID?
so, "select * from mydb" is a transcation?
if i executed "select * from mydb" twice, the XID wil be increased by 2

or ,just the "update","delete" command can be counted
--
View this message in context: http://www.nabble.com/What%27s-the-XID--tp14508639p14508639.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2007-12-27 15:42:43 Re: What's the XID?
Previous Message Phillip Smith 2007-12-26 22:36:22 Re: Dump database more than 1 flat file