Re: Subtransactions + a long-running transaction leading to performance degradation on standbys

2021-08-19 Thread Nikolay Samokhvalov
On Thu, Aug 19, 2021 at 10:04 PM Andrey Borodin wrote: > I just want to note, that on your screenshot unpatched version runs 400K > tps, while patched runs 280K tps. I see the dates are different and this > effect is not observed in [0]. Probably, you run tests on different > machines. Indeed,

Re: Subtransactions + a long-running transaction leading to performance degradation on standbys

2021-08-19 Thread Andrey Borodin
> 20 авг. 2021 г., в 09:45, Nikolay Samokhvalov написал(а): > > The patches changing the SLRU algorithm and adding GUCs to control the buffer > sizes look really promising. Optimization in this area would really help > those who use SAVEPOINTs. I suspect, we have a lot of such users – ORMs l