On Fri, Oct 7, 2022 at 03:23:27PM -0700, Zhihong Yu wrote: > Hi, > I stumbled over: > > https://about.gitlab.com/blog/2021/09/29/ > why-we-spent-the-last-month-eliminating-postgresql-subtransactions/ > > 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. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson
