RE: Perform streaming logical transactions by background workers and parallel apply

Wei Wang (Fujitsu) <wangw.fnst@fujitsu.com>

From: "wangw.fnst@fujitsu.com" <wangw.fnst@fujitsu.com>

To: Amit Kapila <amit.kapila16@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>

Cc: Peter Smith <smithpb2250@gmail.com>, "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>, "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2022-06-15T08:26:40Z

Lists: pgsql-hackers

Attachments

v11-0001-Perform-streaming-logical-transactions-by-backgr.patch (application/octet-stream) patch v11-0001
v11-0002-Test-streaming-apply-option-in-tap-test.patch (application/octet-stream) patch v11-0002
v11-0003-A-temporary-patch-that-includes-patches-in-anoth.patch (application/octet-stream) patch v11-0003
v11-0004-Add-some-checks-before-using-apply-background-wo.patch (application/octet-stream) patch v11-0004
v11-0005-Retry-to-apply-streaming-xact-only-in-apply-work.patch (application/octet-stream) patch v11-0005

On Tues, Jun 14, 2022 11:17 AM I wrote:
> Attach the new patches.
> ......
> 3. Adding a check for the partition table when trying to apply changes in the
> apply background worker. (see patch 0004)
> In additional, the partition cache map on subscriber have several bugs (see
> thread [2]). Because patch 0004 is developed based on the patches in [2], so I
> merged the patches(v4-0001~v4-0003) in [2] into a temporary patch 0003 here.
> After the patches in [2] is committed, I will delete patch 0003 and rebase
> patch 0004.
I added some test cases for this (see patch 0004). In patch 0005, I made
corresponding adjustments according to these test cases.
I also slightly modified the comments about the check for unique index. (see
patch 0004)

Also rebased the temporary patch 0003 because the first patch in thread [1] is
committed (see commit 5a97b132 in HEAD) .

Attach the new patches.
Only changed patches 0004, 0005.

[1] - https://www.postgresql.org/message-id/OSZPR01MB6310F46CD425A967E4AEF736FDA49%40OSZPR01MB6310.jpnprd01.prod.outlook.com

Regards,
Wang wei

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix invalid memory access during the shutdown of the parallel apply worker.
- 3d144c6c8602 16.0 landed
Fix assertion failure in apply worker.
- de63f8dadee4 16.0 landed
Use elog to report unexpected action in handle_streamed_transaction().
- 781ac42d43ab 16.0 landed
Use appropriate wait event when sending data in the apply worker.
- d9d7fe68d35e 16.0 landed
Allow the logical_replication_mode to be used on the subscriber.
- 9f2213a7c575 16.0 landed
Rename GUC logical_decoding_mode to logical_replication_mode.
- 1e8b61735cfb 16.0 landed
Display the leader apply worker's PID for parallel apply workers.
- d540a02a724b 16.0 landed
Improve the code to decide and process the apply action.
- c981d9145dea 16.0 landed
Document the newly added wait events added by commit 216a784829.
- cd06ccd78fcf 16.0 landed
Perform apply of large transactions by parallel workers.
- 216a784829c2 16.0 landed
Wake up a subscription's replication worker processes after DDL.
- c6e1f62e2cee 16.0 cited
Add copyright notices to meson files
- 8284cf5f746f 16.0 cited
Better document logical replication parameters
- a8500750ca0a 16.0 cited
Add a common function to generate the origin name.
- 776e1c8a5d14 16.0 cited
Harmonize parameter names in storage and AM code.
- bfcf1b34805f 16.0 cited
Avoid using list_length() to test for empty list.
- efd0c16becbf 16.0 cited
Improve two comments related to a boolean DefElem's value
- 8445f5a21d40 16.0 cited
Fix partition table's REPLICA IDENTITY checking on the subscriber.
- 26b3455afaa9 15.0 cited
Fix data inconsistency between publisher and subscriber.
- b7658c24c7c1 15.0 cited
Fix cache look-up failures while applying changes in logical replication.
- 5a97b1325453 15.0 cited