Re: subtransaction performance

On Mon, Oct 10, 2022 at 02:20:37PM -0400, Bruce Momjian wrote:
> On Fri, Oct  7, 2022 at 03:23:27PM -0700, Zhihong Yu wrote:
>> I wonder if SAVEPOINT / subtransaction performance has been boosted since the
>> blog was written.
> 
> No, I have not seen any changes in this area since then.  Seems there
> are two problems --- the 64 cache per session and the 64k on the
> replica.  In both cases, it seems sizing is not optimal, but sizing is
> never optimal.  I guess we can look at allowing manual size adjustment,
> automatic size adjustment, or a different approach that is more graceful
> for larger savepoint workloads.

I believe the following commitfest entries might be relevant to this
discussion:

    https://commitfest.postgresql.org/39/2627/
    https://commitfest.postgresql.org/39/3514/
    https://commitfest.postgresql.org/39/3806/

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com