| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: subtransaction performance |
| Date: | 2022-10-11 03:34:33 |
| Message-ID: | 20221011033433.GA1323264@nathanxps13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2022-10-11 03:46:33 | Re: create subscription - improved warning message |
| Previous Message | Junwang Zhao | 2022-10-11 03:29:35 | Re: Non-decimal integer literals |