Re: age(xid) on hot standby
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-17T01:59:00Z
Lists: pgsql-hackers
Excerpts from Tom Lane's message of lun ene 16 12:27:03 -0300 2012: > > Alvaro Herrera <alvherre@commandprompt.com> writes: > > Excerpts from Peter Eisentraut's message of dom ene 15 10:00:03 -0300 2012: > >> On ons, 2011-12-28 at 14:35 -0500, Tom Lane wrote: > >>> 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? > > > Maybe if we have it be invalidated at transaction end, that could work. > > So each new transaction would get a fresh value. > > Yeah, I think that would work. So who's going to work on a patch? Peter, are you? If not, we should add it to the TODO list. -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support