POC: Lock updated tuples in tuple_update() and tuple

POC: Lock updated tuples in tuple_update() and tuple_delete()

Title

POC: Lock updated tuples in tuple_update() and tuple_delete()

Topic

Refactoring

Created

2023-01-02 01:05:29

Last modified

2023-03-01 15:00:14 (2 weeks, 5 days ago)

Latest email

2023-03-20 22:25:11 (15 hours, 56 minutes ago)

Status

2023-03: Needs review

2023-01: Moved to next CF

Target version

Authors

Alexander Korotkov (smagen)

Reviewers

Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov)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 2023-03-20 22:25:11 by Alexander Korotkov <aekorotkov at gmail.com>
Latest 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>
    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
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