public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected] <[email protected]>
To: [email protected] <[email protected]>
To: Amit Kapila <[email protected]>
To: [email protected] <[email protected]>
Cc: Peter Smith <[email protected]>
Cc: Dilip Kumar <[email protected]>
Cc: Masahiko Sawada <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: RE: Perform streaming logical transactions by background workers and parallel apply
Date: Thu, 15 Sep 2022 06:03:13 +0000
Message-ID: <OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com> (raw)
In-Reply-To: <OS3PR01MB6275F145878B4A44586C46CE9E499@OS3PR01MB6275.jpnprd01.prod.outlook.com>
References: <OS0PR01MB5716730C06159452335D870D947F9@OS0PR01MB5716.jpnprd01.prod.outlook.com>
<CAA4eK1Lu-6oXMk7ZaGYLwm3CRLBuzueGbasyHnNpJxu6Mq3mmg@mail.gmail.com>
<OS3PR01MB6275F145878B4A44586C46CE9E499@OS3PR01MB6275.jpnprd01.prod.outlook.com>
On Thu, Sep 15, 2022 1:15 PM Wang, Wei/王 威 <[email protected]> wrote:
>
> Attach the new patch set.
>
Hi,
I did some performance tests for "rollback to savepoint" cases, based on v28
patch.
This test used synchronous logical replication, and compared SQL execution times
before and after applying the patch. It tested different percentage of changes
in the transaction are rolled back (use "rollback to savepoint"), when using
different logical_decoding_work_mem.
The test was performed ten times, and the average of the middle eight was taken.
The results are as follows. The bar charts and the scripts of the test are
attached. The steps to reproduce performance test are at the beginning of
`start_pub.sh`.
RESULT - rollback 10% (5kk)
---------------------------------------------------------------
logical_decoding_work_mem 64kB 256kB 64MB
HEAD 43.752 43.463 42.667
patched 32.646 30.941 31.491
Compare with HEAD -25.39% -28.81% -26.19%
RESULT - rollback 20% (5kk)
---------------------------------------------------------------
logical_decoding_work_mem 64kB 256kB 64MB
HEAD 40.974 40.214 39.930
patched 28.114 28.055 27.550
Compare with HEAD -31.39% -30.23% -31.00%
RESULT - rollback 30% (5kk)
---------------------------------------------------------------
logical_decoding_work_mem 64kB 256kB 64MB
HEAD 37.648 37.785 36.969
patched 29.554 29.389 27.398
Compare with HEAD -21.50% -22.22% -25.89%
RESULT - rollback 50% (5kk)
---------------------------------------------------------------
logical_decoding_work_mem 64kB 256kB 64MB
HEAD 32.312 32.201 32.533
patched 30.238 30.244 27.903
Compare with HEAD -6.42% -6.08% -14.23%
(If "Compare with HEAD" is a positive number, it means worse than HEAD; if it is
a negative number, it means better than HEAD.)
Summary:
In general, when using "rollback to savepoint", the more the amount of data we
need to rollback, the smaller the improvement compared to HEAD. But as such
cases won't be often, this should be okay.
Regards,
Shi yu
Attachments:
[image/png] rollback-50%.png (65.7K, ../OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com/2-rollback-50%25.png)
download | view image
[image/png] rollback-10%.png (64.9K, ../OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com/3-rollback-10%25.png)
download | view image
[image/png] rollback-20%.png (65.0K, ../OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com/4-rollback-20%25.png)
download | view image
[image/png] rollback-30%.png (64.9K, ../OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com/5-rollback-30%25.png)
download | view image
[application/x-zip-compressed] script.zip (4.2K, ../OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com/6-script.zip)
download
view thread (625+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: RE: Perform streaming logical transactions by background workers and parallel apply
In-Reply-To: <OSZPR01MB63103AA97349BBB858E27DEAFD499@OSZPR01MB6310.jpnprd01.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox