| 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: | Whole Thread | Raw Message | 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: |