Lock updated tuples in tuple_update() and tuple_delete()

Edit
Comment/Review
Change Status
ID 4099
Title Lock updated tuples in tuple_update() and tuple_delete()
Topic Refactoring
Created 2023-01-02 01:05:29
Last modified 2024-10-08 02:15:16 (1 month, 1 week ago)
Latest email 2024-03-24 01:12:11 (7 months, 4 weeks ago)
Status
2024-09: Returned with feedback
2024-07: Moved to next CF
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
Target version
Authors Alexander Korotkov (smagen)
Reviewers Pavel Borisov (pborisov), Andres Freund (andresfreund), Chris Travers (einhverfr), vigneshwaran C (vignesh.postgres)Become reviewer
Committer Alexander Korotkov (smagen)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4099
git checkout commitfest/cf/4099
Emails
POC: Lock updated tuples in tuple_update() and tuple_delete()
First at 2022-07-01 11:18:37 by Alexander Korotkov <aekorotkov at gmail.com>
Latest at 2024-03-24 01:12:11 by Alexander Korotkov <aekorotkov at gmail.com>
Latest attachment (v18-0001-Allow-locking-updated-tuples-in-tuple_update-and.patch) at 2024-03-19 15:20:18 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (v18-0001-Allow-locking-updated-tuples-in-tuple_update-and.patch) at 2024-03-19 15:20:18 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Add-EvalPlanQual-delete-returning-isolation-test-v1.patch) at 2023-11-28 09:00:07 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v16-0002-Add-EvalPlanQual-delete-returning-isolation-test.patch) at 2023-04-03 14:12:09 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Add-EvalPlanQual-delete-returning-isolation-test.patch) at 2023-04-03 13:57:37 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (0001-Revise-changes-in-764da7710b-and-11470f544e-v3.patch) at 2023-04-02 00:37:19 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-lazy-tuple-slot-v2.patch) at 2023-03-31 13:57:41 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-lazy-tuple-slot-v1.patch) at 2023-03-29 17:34:10 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-epq-delete-returning-spec-test.patch) at 2023-03-23 00:30:03 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-Evade-extra-table_tuple_fetch_row_version-in-Exe-v15.patch) at 2023-03-20 22:25:11 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Evade-extra-table_tuple_fetch_row_version-in-Exe-v14.patch) at 2023-03-12 16:05:47 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Evade-extra-table_tuple_fetch_row_version-in-Exe-v13.patch) at 2023-03-07 01:45:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (lo-concurrency-11-12.png) at 2023-03-02 18:17:19 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: No)
    Attachment (0001-Allow-locking-updated-tuples-in-tuple_update-and-v12.patch) at 2023-03-02 14:53:08 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (lo-concurrency.png) at 2023-03-02 10:28:56 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: No)
    Attachment (0001-Evade-extra-table_tuple_fetch_row_version-in-Exe-v11.patch) at 2023-03-01 14:57:45 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Allow-locking-updated-tuples-in-tuple_update-and--v9.patch) at 2023-01-09 10:29:18 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Allow-locking-updated-tuples-in-tuple_update-and--v8.patch) at 2023-01-09 10:10:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Allow-locking-updated-tuples-in-tuple_update-and-.patch) at 2023-01-09 09:56:12 from Aleksander Alekseev <aleksander at timescale.com> (Patch: Yes)
    Attachment (0001-Allow-locking-updated-tuples-in-tuple_update-and--v6.patch) at 2023-01-08 22:07:45 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Allow-locking-updated-tuples-in-tuple_update-and-.patch) at 2023-01-06 12:45:29 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (0001-Allow-locking-updated-tuples-in-tuple_update-and--v4.patch) at 2023-01-05 12:11:43 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Lock-updated-tuples-in-tuple_update-and-tuple_del.patch) at 2023-01-04 12:42:34 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Lock-updated-tuples-in-tuple_update-and-tuple_del.patch) at 2023-01-04 09:52:45 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (pgbench-run-2.png) at 2022-07-29 08:11:31 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: No)
    Attachment (0001-Lock-updated-tuples-in-tuple_update-and-tuple_del-v1.patch) at 2022-07-01 11:18:37 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
History
When Who What
2024-10-08 02:15:16 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Returned with feedback
2024-08-01 01:55:14 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-08 08:47:29 Aleksander Alekseev (a.alekseev) Removed a.alekseev from reviewers
2024-04-09 06:19:21 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:56:46 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:51:27 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:06:43 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-02 19:14:45 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-05 15:35:19 Greg Stark (stark) Changed targetversion to None
2023-04-05 02:54:18 Michael Paquier (michael-kun) Closed in commitfest 2023-03 with status: Moved to next CF
2023-04-04 08:55:09 Pavel Borisov (pborisov) Changed reviewers to Andres Freund (andresfreund), Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr), vigneshwaran C (vignesh.postgres), Pavel Borisov (pborisov)
2023-04-04 08:55:09 Pavel Borisov (pborisov) Changed name to Lock updated tuples in tuple_update() and tuple_delete()
2023-03-10 17:16:40 Chris Travers (einhverfr) Posted comment with messageid <167846860062.628976.2440696515718158538.pgcf@coridan.postgresql.org>
2023-03-01 15:00:14 Alexander Korotkov (smagen) New status: Needs review
2023-02-28 21:03:02 Greg Stark (stark) New status: Waiting on Author
2023-01-31 16:27:04 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-08 22:09:00 Alexander Korotkov (smagen) Changed committer to smagen
2023-01-08 22:09:00 Alexander Korotkov (smagen) Changed targetversion to 16
2023-01-06 13:23:02 Pavel Borisov (pborisov) New status: Ready for Committer
2023-01-02 01:06:03 Alexander Korotkov (smagen) Changed reviewers to Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov)
2023-01-02 01:06:03 Alexander Korotkov (smagen) Changed authors to Alexander Korotkov (smagen)
2023-01-02 01:05:29 Alexander Korotkov (smagen) Attached mail thread CAPpHfdua-YFw3XTprfutzGp28xXLigFtzNbuFY8yPhqeq6X5kg@mail.gmail.com
2023-01-02 01:05:29 Alexander Korotkov (smagen) Created patch record
Edit
Comment/Review
Change Status