RE: Conflict detection for update_deleted in logical replication

Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com>

From: "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>

To: Amit Kapila <amit.kapila16@gmail.com>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>

Cc: Nisha Moond <nisha.moond412@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>, shveta malik <shveta.malik@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2024-12-02T11:46:45Z

Lists: pgsql-hackers

Attachments

v13_2-0001-Maintain-the-oldest-non-removeable-tranasction-I.patch (application/octet-stream) patch v13-0001
v13_2-0002-Maintain-the-replication-slot-in-logical-launche.patch (application/octet-stream) patch v13-0002
v13_2-0003-Support-the-conflict-detection-for-update_delete.patch (application/octet-stream) patch v13-0003
v13_2-0004-Add-a-detect_update_deleted-option-to-subscripti.patch (application/octet-stream) patch v13-0004
v13_2-0005-Add-a-tap-test-to-verify-the-new-slot-xmin-mecha.patch (application/octet-stream) patch v13-0005

On Monday, December 2, 2024 7:34 PM Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com> wrote:
> 
> 
> Here is the V13 patch set which addressed this and pending comments in
> [1][2].

I am sorry that I missed to merge some changes in previous patch set. Please check
the attached updated patch set V13_2.

> 
> [1]
> https://www.postgresql.org/message-id/TYAPR01MB5692A6AC6EF2E22A2C
> 9D099AF52A2%40TYAPR01MB5692.jpnprd01.prod.outlook.com
> [2]
> https://www.postgresql.org/message-id/CAA4eK1L-J-iJJ6gpzUc9wJY6eGfB
> bCDmh%2B5fHUZoixnoFbJSNg%40mail.gmail.com

Best Regards,
Hou zj

Commits

Fix intermittent BF failures in 035_conflicts.
- 0f42206531b3 19 (unreleased) landed
Resume conflict-relevant data retention automatically.
- 0d48d393d465 19 (unreleased) landed
Fix intermittent test failure introduced in 6456c6e2c4.
- 01d793698f59 19 (unreleased) landed
Fix Coverity issue reported in commit a850be2fe.
- 5ac3c1ac22cb 19 (unreleased) landed
Add test to prevent premature removal of conflict-relevant data.
- 6456c6e2c4ad 19 (unreleased) landed
Post-commit review fixes for 228c370868.
- 1f7e9ba3ac4e 19 (unreleased) landed
Add max_retention_duration option to subscriptions.
- a850be2fe653 19 (unreleased) landed
Detect and report update_deleted conflicts.
- fd5a1a0c3e56 19 (unreleased) landed
Preserve conflict-relevant data during logical replication.
- 228c37086855 19 (unreleased) landed
Integrate FullTransactionIds deeper into two-phase code
- 62a17a92833d 19 (unreleased) cited
Improve checks for GUC recovery_target_timeline
- fd7d7b719137 19 (unreleased) cited
Prevent excessive delays before launching new logrep workers.
- fd519419c948 18.0 cited
Keep WAL segments by slot's last saved restart LSN
- ca307d5cec90 18.0 cited
Rework some code handling pg_subscription data in psql and pg_dump
- 08691ea958c2 18.0 cited
Use generateClonedIndexStmt to propagate CREATE INDEX to partitions.
- 68dfecbef210 18.0 cited