Re: Speed up transaction completion faster after many relations are accessed in a transaction

From:	David Rowley <dgrowleyml(at)gmail(dot)com>
To:	Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc:	vignesh C <vignesh21(at)gmail(dot)com>, Jacob Champion <jchampion(at)timescale(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>
Subject:	Re: Speed up transaction completion faster after many relations are accessed in a transaction
Date:	2023-09-18 04:08:55
Message-ID:	CAApHDvq1P_8fzb6kOVacifi41cxk8csbaSMTxdjOoNB1qsWN+w@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-02-12 06:33:00 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎  2019-02-18 23:42:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2019-02-18 23:52:08 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>    2019-02-18 23:56:06 from Andres Freund <andres(at)anarazel(dot)de>     2019-02-19 00:01:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2019-02-19 00:06:26 from Andres Freund <andres(at)anarazel(dot)de>       2019-02-19 00:13:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2019-02-19 00:20:12 from Andres Freund <andres(at)anarazel(dot)de>         2019-02-19 08:50:31 from Simon Riggs <simon(at)2ndquadrant(dot)com>          2019-02-20 06:20:37 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎           2019-03-18 19:48:04 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>            2019-03-19 07:53:27 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎             2019-03-19 09:20:22 from "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>             2019-03-19 09:21:42 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎              2019-03-19 15:38:17 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>               2019-03-25 10:44:26 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                2019-03-25 11:48:30 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                 2019-03-26 08:21:20 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                  2019-03-26 08:42:33 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                   2019-03-27 00:21:22 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                  2019-03-26 08:55:01 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                   2019-03-26 10:47:07 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                    2019-03-27 00:26:26 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                2019-04-04 04:37:59 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                 2019-04-04 04:58:12 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                  2019-04-04 20:42:28 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                   2019-04-05 00:04:44 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                    2019-04-05 01:54:23 from "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>                   2019-04-05 01:30:32 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                    2019-04-05 01:38:26 from "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>                    2019-04-05 01:52:36 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                   2019-04-06 03:03:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2019-04-06 05:10:53 from Andres Freund <andres(at)anarazel(dot)de>                     2019-04-06 05:39:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2019-04-08 02:28:12 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                      2019-04-08 02:40:12 from 'Andres Freund' <andres(at)anarazel(dot)de>                       2019-04-08 02:54:16 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                        2019-04-08 02:58:43 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2019-04-08 03:46:59 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                          2019-04-08 12:10:43 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                    2019-04-07 08:07:58 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                    2019-04-07 13:55:31 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                     2019-04-07 14:20:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2019-04-07 14:36:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2019-04-07 14:41:12 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2019-04-07 14:59:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2019-04-07 15:07:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2019-04-07 15:20:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2019-04-07 15:40:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                           2019-04-07 15:47:19 from Andres Freund <andres(at)anarazel(dot)de>                            2019-04-07 15:53:10 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                           2019-04-07 16:09:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2019-04-07 16:48:11 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                            2019-06-15 03:28:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                             2019-06-17 03:04:51 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                              2019-06-26 23:00:56 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                               2019-06-27 00:58:51 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                2019-07-18 02:53:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                 2019-07-21 09:37:28 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                  2019-07-22 00:47:28 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                   2019-07-22 01:21:04 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                    2019-07-22 02:21:16 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                     2019-07-22 02:29:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                      2019-07-22 04:34:59 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                       2019-07-22 04:50:38 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                   2019-07-22 11:14:48 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                    2019-07-23 03:46:59 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                     2019-07-23 06:11:51 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                      2019-07-23 16:13:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2019-07-24 03:05:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                        2019-07-24 04:16:47 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                         2019-07-24 07:14:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                          2019-07-24 17:49:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2019-08-01 22:15:54 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                           2019-08-14 07:25:10 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                            2019-08-15 22:30:59 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                            2019-09-02 18:14:24 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                             2019-09-03 05:12:53 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                              2019-09-25 21:08:05 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                               2019-09-26 07:11:53 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎                                                2019-12-01 02:59:13 from Michael Paquier <michael(at)paquier(dot)xyz>                                                 2020-02-01 11:41:09 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                            2021-06-20 13:56:13 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                             2021-06-20 17:06:47 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                              2021-07-12 06:55:42 from David Rowley <dgrowleyml(at)gmail(dot)com>                                             2021-07-12 07:23:57 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                              2021-07-20 05:04:19 from David Rowley <dgrowleyml(at)gmail(dot)com>                                               2021-10-01 07:03:09 from Michael Paquier <michael(at)paquier(dot)xyz>                                                2021-12-03 07:36:45 from Michael Paquier <michael(at)paquier(dot)xyz>                                                 2022-01-01 01:44:46 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                  2022-01-01 02:43:07 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                   2022-03-15 02:47:17 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                    2022-04-05 15:40:52 from Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>                                                     2022-04-07 04:05:19 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                      2022-08-02 19:04:11 from Jacob Champion <jchampion(at)timescale(dot)com>                                                       2022-08-03 03:33:57 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                        2022-11-03 15:42:05 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                                                         2022-11-15 21:03:50 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                        2023-01-19 11:25:49 from vignesh C <vignesh21(at)gmail(dot)com>                                                         2023-01-24 03:57:37 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                          2023-01-31 14:07:20 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                           2023-02-10 02:51:07 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                            2023-07-05 09:44:34 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                             2023-09-11 12:00:10 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                              2023-09-15 10:37:11 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                               2023-09-18 04:08:55 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                                2023-11-09 16:18:21 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi> 📎                                                                 2024-01-09 06:24:19 from vignesh C <vignesh21(at)gmail(dot)com>                                                          2023-02-07 18:05:36 from Andres Freund <andres(at)anarazel(dot)de>                                               2021-10-06 16:20:52 from Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>                                  2019-07-22 16:07:00 from Andres Freund <andres(at)anarazel(dot)de>              2019-04-05 10:56:44 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>     2019-02-19 00:05:44 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>    2019-02-18 23:57:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2019-02-19 00:16:39 from Andres Freund <andres(at)anarazel(dot)de>    2019-02-19 00:24:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2019-02-19 00:41:07 from Andres Freund <andres(at)anarazel(dot)de>      2019-02-19 01:29:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2019-02-19 03:24:20 from Andres Freund <andres(at)anarazel(dot)de>  2019-02-19 11:57:32 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>   2019-02-20 05:42:41 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v8-0001-wip-resowner-lock-release-all.patch	application/octet-stream	52.7 KB

In response to

• Re: Speed up transaction completion faster after many relations are accessed in a transaction at 2023-09-15 10:37:11 from Heikki Linnakangas

Responses

• Re: Speed up transaction completion faster after many relations are accessed in a transaction at 2023-11-09 16:18:21 from Heikki Linnakangas

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	杨伯宇 (长堂)	2023-09-18 05:00:59	function "cursor_to_xmlschema" causes a crash
Previous Message	Amit Kapila	2023-09-18 04:01:57	Re: Add 'worker_type' to pg_stat_subscription