Re: SUBTRANS: Minimizing calls to SubTransSetParent()

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Julien Tachoires <julmon(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: SUBTRANS: Minimizing calls to SubTransSetParent()
Date: 2022-11-17 20:29:53
Message-ID: 0476814e-e003-7609-0fc7-5eae36956fe3@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/17/22 18:29, Simon Riggs wrote:
> On Thu, 17 Nov 2022 at 17:04, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> wrote:
>>
>> New version with greatly improved comments coming very soon.
>
>>> Perhaps it would be a good idea to split up the patch. The business
>>> about making pg_subtrans flat rather than a tree seems like a good
>>> idea in any event, although as I said it doesn't seem like we've got
>>> a fleshed-out version of that here. We could push forward on getting
>>> that done and then separately consider the rest of it.
>>
>> Yes, I thought you might ask that so, after some thought, have found a
>> clean way to do that and have split this into two parts.
>
> Attached.
>
> 002 includes many comment revisions, as well as flattening the loops
> in SubTransGetTopmostTransaction and TransactionIdDidCommit/Abort
> 003 includes the idea to not-always do SubTransSetParent()
>

I'm a bit confused by the TransactionIdsAreOnSameXactPage naming. Isn't
this really checking clog pages?

regards

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-11-17 20:38:15 Re: Reducing power consumption on idle servers
Previous Message Tom Lane 2022-11-17 20:15:04 Re: ubsan fails on 32bit builds