Re: Least Active Transaction ID function

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

In response to

Responses

Browse pgsql-hackers by date

  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: