Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: What's the XID?
- From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Re: What's the XID?
- Date: Thu, 27 Dec 2007 10:42:43 -0500
On Wed, Dec 26, 2007 at 05:48:14PM -0800, ivan.hou wrote: > > XID is transcation ID? Yes. > so, "select * from mydb" is a transcation? Yes. > if i executed "select * from mydb" twice, the XID wil be increased by 2 Yep. Whereas if you did BEGIN; SELECT 1; SELECT 1; COMMIT; the xid would be increased by 1. A
- Follow-Ups:
- Re: What's the XID?
- From: Tom Lane
- Re: What's the XID?
- References:
- What's the XID?
- From: ivan.hou
- What's the XID?
- Prev by Date: What's the XID?
- Next by Date: high-availability on MS Windows cluster -- need insights
- Previous by thread: What's the XID?
- Next by thread: Re: What's the XID?
- Indexes: