On Wed, Jul 23, 2014 at 3:53 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote: > Hi All, > > On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote: >> >> Hi All, >> >> I am doing programming with postgresql source code. I want to find out the >> function which can give me Least active transaction id currenty in the >> system. >> >> Is there any function which can give me that? >> >> Regards, >> Rohit Goyal > > 1> I know that somewhere there is an active transaction list in postgresql. > At any point of time, I want to get the smallest transaction present in this > active tx list or I want to get the transaction id before which all > transaction smaller than that are committed/aborted. > > Is there any function which can give me this value?
See the RecentXmin calculation in GetSnapshotData.
This was really -2 helpful.
1. Can I use this xmin variable directly anytime anywhere in my code as it is a global variable.
2. What is the difference b/w recentXmin and RecentGlobalXmin. I read the description but any small detail can clear my mind. :)
Thanks in advance!!
> 2> I found a function giving GetStableLatestTransactionId(), please tel me > what this function gives. I was not able to understand the description given > above it.
I don't know how to help with this; the description seems clear to me.
This is not important now, as you have already told me the variable and file for recentXmin.:)
