Re: Conflict Detection and Resolution

From: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Ajin Cherian <itsajin(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Jan Wieck <jan(at)wi3ck(dot)info>, 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>
Subject: Re: Conflict Detection and Resolution
Date: 2024-08-30 05:30:46
Message-ID: CABdArM5PRhMFDVsK8Nbq0Tf26mwKbkj1vcGMqkHKOZEGfqrZBg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here is the v11 patch-set. Changes are:
1) Updated conflict type names in accordance with the recent commit[1] as -
update_differ --> update_origin_differs
delete_differ --> delete_origin_differs

2) patch-001:
- Implemented the RESET command to restore the default resolvers as
suggested in pt.2a & 2b in [2]

3) patch-004:
- Rebased the patch which implements last_update_wins resolver and
clock-skew management.
- Restricts the setting of two_phase and last_update_wins together
- Prevents the start of parallel apply-worker if 'last_update_wins'
is configured for any conflict_type.
- Added test cases for last_update_wins in 034_conflict_resolver.pl

Thanks, Shveta for your help in patch-004 solutions and thank you Ajin
for providing RESET command changes(patch-001).

[1]: https://www.postgresql.org/message-id/CAA4eK1%2BpoV1dDqK%3Dhdv-Zh2m2kBdB%3Ds1TBk8MwscgdzULBonbw%40mail.gmail.com
[2]: https://www.postgresql.org/message-id/CAJpy0uBrXZE6LLofX5tc8WOm5F%2BFNgnQjRLQerOY8cOqqvtrNg%40mail.gmail.com

--
Thanks,
Nisha

Attachment Content-Type Size
v11-0001-Add-CONFLICT-RESOLVERS-into-the-syntax-for-CREAT.patch application/octet-stream 60.3 KB
v11-0002-Conflict-resolvers-for-insert-update-and-delete.patch application/octet-stream 59.9 KB
v11-0003-Conflict-resolution-for-update_exists-conflict-t.patch application/octet-stream 15.6 KB
v11-0004-Manage-Clock-skew-and-implement-last_update_wins.patch application/octet-stream 45.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stepan Neretin 2024-08-30 05:34:08 Supporting pg freeze in pg_dump, restore.
Previous Message Peter Smith 2024-08-30 05:23:04 Re: Collect statistics about conflicts in logical replication