Lock updated tuples in tuple_update() and tuple_delete()

Edit

Title

Topic

Refactoring

Created

2023-01-02 01:05:29

Last modified

2024-08-01 01:55:14 (1 month, 2 weeks ago)

Latest email

2024-03-24 01:12:11 (5 months, 3 weeks ago)

Status

2024-09: Needs review

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

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-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