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