Postgres Pro
Downloads
Home   >   mailing lists

Re: age(xid) on hot standby - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: age(xid) on hot standby
Date
Msg-id 1326632403.32048.1.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: age(xid) on hot standby  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: age(xid) on hot standby  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
On ons, 2011-12-28 at 14:35 -0500, Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Excerpts from Peter Eisentraut's message of mié dic 28 15:04:09 -0300 2011:
> >> On a hot standby, this fails with:
> >> ERROR:  cannot assign TransactionIds during recovery
> 
> > I think we could just have the xid_age call
> > GetCurrentTransactionIdIfAny, and if that returns InvalidXid, use
> > ReadNewTransactionId instead.  That xid_age assigns a transaction seems
> > more of an accident than really intended.
> 
> The trouble with using ReadNewTransactionId is that it makes the results
> volatile, not stable as the function is declared to be.

Could we alleviate that problem with some caching within the function?

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: exit() calls in libraries
Next
From: Andrew Dunstan
Date:
Subject: Re: lots of unused variable warnings in assert-free builds