Re: suboverflowed subtransactions concurrency performance optimize - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: suboverflowed subtransactions concurrency performance optimize
Date
Msg-id CAH2-WznPrtOHmx6FHkn1rYh+HANp7rn1QQrpttfLCxMyyJtWVA@mail.gmail.com
Whole thread Raw
In response to Re: suboverflowed subtransactions concurrency performance optimize  (Andres Freund <andres@anarazel.de>)
Responses Re: suboverflowed subtransactions concurrency performance optimize
List pgsql-hackers
On Fri, May 27, 2022 at 8:55 AM Andres Freund <andres@anarazel.de> wrote:
> > Anyway, how about if we clear this cache for subtrans whenever
> > TransactionXmin is advanced and cachedFetchSubXid precedes it? The
> > comments atop SubTransGetTopmostTransaction seem to state that we
> > don't care about the exact topmost parent when the intermediate one
> > precedes TransactionXmin. I think it should preserve the optimization
> > because anyway for such cases there is a fast path in
> > SubTransGetTopmostTransaction.
>
> There's not even a proof this does speed up anything useful! There's not a
> single benchmark for the patch.

I find it hard to believe that there wasn't even a cursory effort at
performance validation before this was committed, but that's what it
looks like.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Assert name/short_desc to prevent SHOW ALL segfault
Next
From: Andres Freund
Date:
Subject: Re: suboverflowed subtransactions concurrency performance optimize