Skip site navigation (1) Skip section navigation (2)

Re: the XID question

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: Chris Browne <cbbrowne(at)acm(dot)org>
Subject: Re: the XID question
Date: 2011-01-19 18:31:51
Message-ID: 201101191931.52841.andres@anarazel.de (view raw or flat)
Thread:
Lists: pgsql-performance
On Wednesday, January 19, 2011 07:06:58 PM Chris Browne wrote:
> Kevin(dot)Grittner(at)wicourts(dot)gov ("Kevin Grittner") writes:
> > Filip Rembia*kowski<plk(dot)zuber(at)gmail(dot)com> wrote:
> >> 2011/1/19 Charles.Hou <givemeegn(at)gmail(dot)com>:
> >>> " select * from mybook" SQL command also increase the XID ?
> >> 
> >> Yes. Single SELECT is a transaction. Hence, it needs a transaction
> >> ID.
> > 
> > No, not in recent versions of PostgreSQL.  There's virtual
> > transaction ID, too; which is all that's needed unless the
> > transaction writes something.
> > 
> > Also, as a fine point, if you use explicit database transactions
> > (with BEGIN or START TRANSACTION) then you normally get one XID for
> > the entire transaction, unless you use SAVEPOINTs.
> 
> Erm, "not *necessarily* in recent versions of PostgreSQL."
> 
> A read-only transaction won't consume XIDs, but if you don't expressly
> declare it read-only, they're still liable to get eaten...
No. The Xid is generally only allocated at the first place a real xid is 
needed. See GetCurrentTransactionId, AssignTransactionId in xact.c and the 
caller of the former.

Andres

In response to

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-01-19 18:41:06
Subject: Re: the XID question
Previous:From: Chris BrowneDate: 2011-01-19 18:06:58
Subject: Re: the XID question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group