Re: Least Active Transaction ID function
| От | Rohit Goyal |
|---|---|
| Тема | Re: Least Active Transaction ID function |
| Дата | |
| Msg-id | CANqGtSumHUZAh7uK8WAS3snTxuDCz5BES_GGQdm7MQZdyXEpfw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Least Active Transaction ID function (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: Least Active Transaction ID function
|
| Список | pgsql-hackers |
Hi Robert,
--
Regards,
On Thu, Jul 24, 2014 at 9:32 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Wed, Jul 23, 2014 at 3:53 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:See the RecentXmin calculation in GetSnapshotData.
> 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?
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 meI don't know how to help with this; the description seems clear to me.
> what this function gives. I was not able to understand the description given
> above it.
This is not important now, as you have already told me the variable and file for recentXmin.:)
Regards,
Rohit
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Regards,
Rohit Goyal
В списке pgsql-hackers по дате отправления: