Postgres Pro
Downloads
Home   >   mailing lists

Re: the XID question - Mailing list pgsql-performance

From Filip Rembiałkowski
Subject Re: the XID question
Date
Msg-id AANLkTim8MsWWPw3hL_U_U2cdv3us24MgP7TwcFJp2hVy@mail.gmail.com
Whole thread Raw
In response to the XID question  ("Charles.Hou" <givemeegn@gmail.com>)
Responses Re: the XID question  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
2011/1/19 Charles.Hou <givemeegn@gmail.com>:
> what's the definetion of XID?

XID == "Transaction ID".

> " select * from mybook" SQL command also increase the XID ?

Yes. Single SELECT is a transaction. Hence, it needs a transaction ID.


greets,
Filip

pgsql-performance by date:

Previous
From: "Charles.Hou"
Date:
Subject: Re: the XID question
Next
From: "Kevin Grittner"
Date:
Subject: Re: the XID question