开启synchronous_commit='remote_apply'后，事务提交延迟过大

【标题描述】:
开启synchronous_commit='remote_apply'后，事务提交延迟过大，如下所示很小的数据量，需要3秒的等待时间。

MogDB=# select now();insert into t4 select generate_series(1,1000);select now();
              now              
-------------------------------
 2023-06-20 21:37:06.859697-04
(1 row)

INSERT 0 1000
              now              
-------------------------------
 2023-06-20 21:37:09.866949-04
(1 row)

MogDB=#

【测试环境】(单机/1主x备x级联备):
一主一同步备，主库无压力

【预期输出】:
事务提交基本无延迟

【实际输出】:
事务提交延迟3秒

Hey @Movead, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @Movead, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

验收日期：2023-8-21
验收版本：gsql ((openGauss 5.1.0 build fd7e64df) compiled at 2023-07-26 11:32:47 commit 0 last mr )
验收结论：通过
优化前平均耗时：3000ms
输入图片说明
优化后平均耗时：30ms

验收日期：2023-10-18
验收版本：gsql ((openGauss 5.0.1 build f766addf) compiled at 2023-10-07 18:07:51 commit 0 last mr )
验收结论：通过
输入图片说明

GVP openGauss / openGauss-server

内容风险标识

评论 (4)

GVPopenGauss / openGauss-server

内容风险标识