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

From:	Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
To:	Andres Freund <andres(at)anarazel(dot)de>
Cc:	Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Chris Travers <chris(dot)travers(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: POC: Lock updated tuples in tuple_update() and tuple_delete()
Date:	2023-04-03 14:12:09
Message-ID:	CALT9ZEGMyqaa2VNWYwCguZoZdExNv2agcthnUF78GHi_0wCh4g@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2022-07-01 11:18:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎  2022-07-05 13:38:28 from Aleksander Alekseev <aleksander(at)timescale(dot)com>   2022-07-05 13:41:27 from Aleksander Alekseev <aleksander(at)timescale(dot)com>    2022-07-07 09:42:52 from Aleksander Alekseev <aleksander(at)timescale(dot)com>     2022-07-12 10:29:44 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>      2022-07-29 08:11:31 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎       2022-07-29 08:35:33 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>  2023-01-04 09:40:48 from vignesh C <vignesh21(at)gmail(dot)com>   2023-01-04 09:52:45 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎    2023-01-04 12:42:34 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎     2023-01-04 14:05:03 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>      2023-01-05 12:11:43 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎       2023-01-06 12:45:29 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎        2023-01-08 18:33:40 from Mason Sharp <masonlists(at)gmail(dot)com>         2023-01-08 22:07:45 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎          2023-01-09 09:56:12 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎           2023-01-09 10:10:56 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎            2023-01-09 10:29:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎             2023-01-09 10:40:51 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>              2023-01-09 10:46:42 from Aleksander Alekseev <aleksander(at)timescale(dot)com>              2023-01-09 10:46:50 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>               2023-01-09 23:38:58 from Andres Freund <andres(at)anarazel(dot)de>             2023-01-10 01:07:02 from Andres Freund <andres(at)anarazel(dot)de>              2023-02-28 21:02:46 from Gregory Stark <stark(at)postgresql(dot)org>               2023-02-28 21:08:58 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>              2023-03-01 14:57:45 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎               2023-03-02 10:28:56 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                2023-03-02 14:53:08 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                 2023-03-02 18:17:19 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                  2023-03-02 20:16:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                   2023-03-07 01:45:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                    2023-03-08 01:21:57 from Andres Freund <andres(at)anarazel(dot)de>                     2023-03-10 08:47:56 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                      2023-03-10 17:16:40 from Chris Travers <chris(dot)travers(at)gmail(dot)com>                       2023-03-12 16:05:47 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                        2023-03-20 22:25:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                         2023-03-23 00:30:03 from Andres Freund <andres(at)anarazel(dot)de> 📎                          2023-03-23 15:08:36 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                           2023-03-23 16:50:20 from Andres Freund <andres(at)anarazel(dot)de>                            2023-03-24 00:39:12 from Andres Freund <andres(at)anarazel(dot)de>                             2023-03-27 10:49:22 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                              2023-03-29 17:34:10 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                               2023-03-31 13:57:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                2023-04-01 05:21:27 from Andres Freund <andres(at)anarazel(dot)de>                                 2023-04-01 07:24:09 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                 2023-04-02 00:37:19 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                  2023-04-02 00:47:18 from Andres Freund <andres(at)anarazel(dot)de>                                   2023-04-03 13:57:05 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                   2023-04-03 13:57:37 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                                    2023-04-03 14:12:09 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                                     2023-04-03 22:25:46 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                      2023-04-05 02:54:06 from Michael Paquier <michael(at)paquier(dot)xyz>                                       2023-11-28 09:00:07 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                                        2024-03-19 15:20:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                         2024-03-24 01:12:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                2023-03-07 01:50:29 from Andres Freund <andres(at)anarazel(dot)de>                 2023-03-07 02:09:56 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                  2023-03-07 16:26:19 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                   2023-03-07 23:17:21 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v16-0002-Add-EvalPlanQual-delete-returning-isolation-test.patch	application/octet-stream	3.4 KB
v16-0001-Allow-locking-updated-tuples-in-tuple_update-and.patch	application/octet-stream	60.9 KB

In response to

• Re: POC: Lock updated tuples in tuple_update() and tuple_delete() at 2023-04-03 13:57:37 from Pavel Borisov

Responses

• Re: POC: Lock updated tuples in tuple_update() and tuple_delete() at 2023-04-03 22:25:46 from Alexander Korotkov

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2023-04-03 14:19:49	Re: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind
Previous Message	Ashutosh Bapat	2023-04-03 14:11:37	Re: Infinite Interval