Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ryuYq-0014au-VL for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Apr 2024 14:22:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ryuYp-004a9o-Cm for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Apr 2024 14:22:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ryuYo-004a9U-Un for pgsql-hackers@lists.postgresql.org; Mon, 22 Apr 2024 14:22:23 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ryuYi-002LBw-84 for pgsql-hackers@lists.postgresql.org; Mon, 22 Apr 2024 14:22:22 +0000 Received: from sogo.postgrespro.ru (unknown [192.168.2.5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix/587) with ESMTPS id 3A705E20EAF; Mon, 22 Apr 2024 17:22:14 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1713795734; bh=bSASv0hh2Q6yTOehmOcAxe24jdzvm+bP2JgJ0yNRfow=; h=From:In-Reply-To:References:Date:Cc:To:Message-ID:Subject: User-Agent:From; b=pdAokOAkh6xSrICWRlgqDWPsufx1ja4ShJMn8GI5rXV0c5qkPO1j09cURoO1Dqtw9 nNU1Cf0IEzvQ2HYRmv1eAvwWupIVaWg2+HyOo0LmqAjYF3ZrCt+YY4aOffy1f0U/GA R9gvVv2MzOh+hEl6xNKQUdk35T5hQLPVaGOWItkmSYxn0ZcD2Wq+acg96Th9A1N4Wz SXqp8Bpda+C3XzYJ+q+ku3/qG/ttsHflkgN1t22NHBZp3KUetxc4L6z+uVMpZ56GIv zWzNywD7cFkHPW/HggEgyTBX+kB1zVmc0+1mR1dgjs2kAQgCi3p5PIlE0NGHA0DkTb mTh8CCOVCKS4Q== From: "Vitaly Davydov" In-Reply-To: Content-Type: multipart/alternative; boundary="----=_=-_OpenGroupware_org_NGMime-64466-1713795734.092737-0------" X-Forward: 46.31.29.106 References: <8fab8-65d74c80-1-2f28e880@39088166> <99df2-65d8d200-1-63c26880@172687752> <23d1ca-66169f80-1f-5a90aa00@207285398> <26b30e-661d4880-9-62d2df00@231402233> Date: Mon, 22 Apr 2024 17:22:14 +0300 Cc: "Amit Kapila" , "Ajin Cherian" , =?utf-8?q?pgsql-hackers=40lists=2Epostgresql=2Eorg?= To: "Hayato Kuroda (Fujitsu)" MIME-Version: 1.0 Message-ID: Subject: =?utf-8?q?RE=3A?= Slow catchup of 2PC (twophase) transactions on replica in LR User-Agent: SOGoMail 5.10.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_=-_OpenGroupware_org_NGMime-64466-1713795734.092737-0------ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 1458 Dear Hayato, On Monday, April 22, 2024 15:54 MSK, "Hayato Kuroda (Fujitsu)" wrote: =C2=A0> Dear Vitaly, > > > I looked at the patch and realized that I can't try it easily in th= e near future > > because the solution I'm working on is based on PG16 or earlier. Th= is patch is > > not easily applicable to the older releases. I have to port my solu= tion to the > > master, which is not done yet. > > We also tried to port our patch for PG16, but the largest barrier was= that a > replication command ALTER=5FSLOT is not supported. Since the slot opt= ion > two=5Fphase > can't be modified, it is difficult to skip decoding PREPARE command e= ven when > altering the option from true to false. > IIUC, Adding a new feature (e.g., replication command) for minor upda= tes is > generally > prohibited > ... Attached patch set is a ported version for PG16, which breaks ABI. This= can be used for testing purpose, but it won't be pushed to REL=5F16=5FSTABLE. At least, this patchset can pass my github CI. Can you apply and check whether your issue is solved?=E2=80=8B=E2=80=8B= =E2=80=8B=E2=80=8B=E2=80=8B=E2=80=8BIt is fantastic. Thank you for your= help! I will definitely try your patch. I need some time to test and i= ncorporate it. I also plan to port my stuff to the master branch to sim= plify testing of patches. With best regards, =E2=80=8B=E2=80=8B=E2=80=8B=E2=80=8B=E2=80=8BVitaly Davydov =C2=A0 ------=_=-_OpenGroupware_org_NGMime-64466-1713795734.092737-0------ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Length: 1846 Dear Hayato,

On Monday, April 22, 2024 15:54 MSK, "Hay= ato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com> wrote:
&nb= sp;
> Dear Vitaly,
&g= t;
> > I looked at the patch and realized that I can't try i= t easily in the near future
> > because the solution I'm wor= king on is based on PG16 or earlier. This patch is
> > not e= asily applicable to the older releases. I have to port my solution to t= he
> > master, which is not done yet.
>
> We= also tried to port our patch for PG16, but the largest barrier was tha= t a
> replication command ALTER=5FSLOT is not supported. Since = the slot option
> two=5Fphase
> can't be modified, it i= s difficult to skip decoding PREPARE command even when
> alteri= ng the option from true to false.
> IIUC, Adding a new feature = (e.g., replication command) for minor updates is
> generally> prohibited
>
...

Attached patch set is = a ported version for PG16, which breaks ABI. This can be used
for = testing purpose, but it won't be pushed to REL=5F16=5FSTABLE.
At l= east, this patchset can pass my github CI.

Can you apply and= check whether your issue is solved?=E2=80=8B=E2=80=8B=E2=80=8B=E2=80=8B= =E2=80=8B=E2=80=8B
It is fantastic. Thank you for your help= ! I will definitely try your patch. I need some time to test and incorp= orate it. I also plan to port my stuff to the master branch to simplify= testing of patches.

With best regards,
=E2=80=8B=E2=80= =8B=E2=80=8B=E2=80=8B=E2=80=8BVitaly Davydov

  ------=_=-_OpenGroupware_org_NGMime-64466-1713795734.092737-0--------