Re: Conflict Detection and Resolution

From: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
Subject: Re: Conflict Detection and Resolution
Date: 2024-07-05 06:52:29
Message-ID: CABdArM47myyKnOU4LB54k3wmgpFu63s2gxmAQVK-DdWzCLKAaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Please find the new patch set (v4). It implements the resolvers for
conflict type : 'delete_differ'.
Supported resolutions for ‘delete_differ’ are :
- ‘last_update_wins': Apply the change with the latest timestamp (default)
- 'remote_apply': Apply the remote delete.
- 'keep_local': Skip the remote delete and continue.
- 'error': The apply worker will error out and restart.

The changes made in the patches are as follows:
- Updated the conflict detection patch (patch0001) to the latest
version from [1], which implements delete_differ conflict detection.
- Patch0002 now supports resolver settings for delete_differ.
- Patch0003 implements resolutions for delete_differ as well.
- Patch0004 includes changes to support last_update_wins resolution
for delete_differ.

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

--
Thanks,
Nisha

Attachment Content-Type Size
v4-0001-Detect-and-log-conflicts-in-logical-replication.patch application/octet-stream 95.5 KB
v4-0002-DDL-command-to-configure-Global-Conflict-Resolver.patch application/octet-stream 26.5 KB
v4-0003-Implement-conflict-resolution-for-INSERT-UPDATE-a.patch application/octet-stream 36.3 KB
v4-0004-Manage-Clock-skew-and-implement-last_update_wins.patch application/octet-stream 22.3 KB
v4-0005-Configure-table-level-conflict-resolvers.patch application/octet-stream 48.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 杨伯宇 (长堂) 2024-07-05 07:12:37 speed up pg_upgrade with large number of tables
Previous Message Amit Kapila 2024-07-05 06:50:49 Re: walsender.c comment with no context is hard to understand