Re: age(xid) on hot standby

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: age(xid) on hot standby
Дата
Msg-id 1326632403.32048.1.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: age(xid) on hot standby  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: age(xid) on hot standby  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: exit() calls in libraries
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: lots of unused variable warnings in assert-free builds