On Wed, Jun 4, 2025 at 8:22 PM Ajin Cherian <itsa...@gmail.com> wrote: > > On Tue, Jun 3, 2025 at 4:25 PM Ajin Cherian <itsa...@gmail.com> wrote: > > > > On Tue, Jun 3, 2025 at 3:55 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > > > > > > > > You haven't shared the exact test scenario, but I am assuming the > > > above tests are for very large transactions, as you are comparing > > > streaming and non-streaming modes. Can we see results with short > > > transaction size (say one insert or one update, or one delete) as > > > well? > > > > > > > Attaching the scripts I used for my tests. Yes, I used transactions > > with large inserts. I will redo the tests with short single inserts > > and share the results here. > > I redid the tests with 10k small transactions (single inserts) and the > results are not great with the patch:
I did some more tests with 20k and 30k transactions. Results attached. 20k Small Transactions No transactions published: +13.9% improvement Half transactions published: +0.9% improvement All transactions published: +1.4% improvement 30k Small Transactions No transactions published: +15.9% improvement Half transactions published: −1.3% degradation All transactions published: +1.3% improvement regards, Ajin Cherian Fujitsu Australia
