From: | Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Least Active Transaction ID function |
Date: | 2014-07-23 19:53:57 |
Message-ID: | CANqGtSshwi+RyRxdNWOMtd2jaHLP3LiFPQ=6+DqBR2n+tvX+xg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)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?
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.
Thanks for support in advance :)!!
Regards,
Rohit Goyal
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2014-07-23 20:05:22 | Re: Making joins involving ctid work for the benefit of UPSERT |
Previous Message | Krystian Bigaj | 2014-07-23 19:52:39 | Re: |