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

От

Michael Paquier

Тема

Дата

1 октября 2021 г. в 07:03:09

Msg-id

YVayrWJ3yhb8Lka1@paquier.xyz

обсуждение

Ответ на

Re: Speed up transaction completion faster after many relations are accessed in a transaction (David Rowley)

Список

pgsql-hackers

Дерево обсуждения

Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 12 февраля 2019 г. в 06:33:00

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 18 февраля 2019 г. в 23:42:32

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 19 февраля 2019 г. в 00:16:39

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 19 февраля 2019 г. в 00:24:54

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 19 февраля 2019 г. в 00:41:07

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 19 февраля 2019 г. в 01:29:29

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 19 февраля 2019 г. в 03:24:20

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 18 февраля 2019 г. в 23:52:08

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 18 февраля 2019 г. в 23:57:50

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 18 февраля 2019 г. в 23:56:06

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 19 февраля 2019 г. в 00:01:06

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 19 февраля 2019 г. в 00:06:26

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 19 февраля 2019 г. в 00:13:31

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 19 февраля 2019 г. в 00:20:12

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Simon Riggs <simon@2ndquadrant.com> 19 февраля 2019 г. в 08:50:31

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 20 февраля 2019 г. в 06:20:37

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 18 марта 2019 г. в 19:48:04

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 19 марта 2019 г. в 07:53:27

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 19 марта 2019 г. в 09:21:42

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 5 апреля 2019 г. в 10:56:44

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 19 марта 2019 г. в 15:38:17

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 25 марта 2019 г. в 10:44:26

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 4 апреля 2019 г. в 04:37:59

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> 4 апреля 2019 г. в 04:58:12

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 4 апреля 2019 г. в 20:42:28

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 5 апреля 2019 г. в 00:04:44

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com> 5 апреля 2019 г. в 01:54:23

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 6 апреля 2019 г. в 03:03:11

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 7 апреля 2019 г. в 08:07:58

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 6 апреля 2019 г. в 05:10:53

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 8 апреля 2019 г. в 02:28:12

Re: Speed up transaction completion faster after many relations areaccessed in a transaction 'Andres Freund' <andres@anarazel.de> 8 апреля 2019 г. в 02:40:12

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 8 апреля 2019 г. в 02:54:16

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 8 апреля 2019 г. в 02:58:43

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 8 апреля 2019 г. в 03:46:59

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 8 апреля 2019 г. в 12:10:43

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 6 апреля 2019 г. в 05:39:17

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 13:55:31

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2019 г. в 14:20:21

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 14:36:05

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2019 г. в 14:59:04

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 15:07:37

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2019 г. в 15:20:43

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 15:40:52

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 7 апреля 2019 г. в 15:47:19

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 15:53:10

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2019 г. в 16:09:40

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 16:48:11

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 15 июня 2019 г. в 03:28:05

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 17 июня 2019 г. в 03:04:51

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 26 июня 2019 г. в 23:00:56

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 27 июня 2019 г. в 00:58:51

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 18 июля 2019 г. в 02:53:50

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 21 июля 2019 г. в 09:37:28

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 22 июля 2019 г. в 00:47:28

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 22 июля 2019 г. в 01:21:04

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 22 июля 2019 г. в 02:21:16

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 22 июля 2019 г. в 02:29:33

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 22 июля 2019 г. в 04:34:59

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 22 июля 2019 г. в 04:50:38

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 22 июля 2019 г. в 11:14:48

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 23 июля 2019 г. в 03:46:59

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 23 июля 2019 г. в 06:11:51

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 23 июля 2019 г. в 16:13:40

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 24 июля 2019 г. в 03:05:37

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 24 июля 2019 г. в 04:16:47

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 24 июля 2019 г. в 07:14:35

Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us> 24 июля 2019 г. в 17:49:00

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Thomas Munro <thomas.munro@gmail.com> 1 августа 2019 г. в 22:15:54

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 14 августа 2019 г. в 07:25:10

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com> 15 августа 2019 г. в 22:30:59

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Alvaro Herrera <alvherre@2ndquadrant.com> 2 сентября 2019 г. в 18:14:24

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 3 сентября 2019 г. в 05:12:53

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Alvaro Herrera <alvherre@2ndquadrant.com> 25 сентября 2019 г. в 21:08:05

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 26 сентября 2019 г. в 07:11:53

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Michael Paquier <michael@paquier.xyz> 1 декабря 2019 г. в 02:59:13

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com> 1 февраля 2020 г. в 11:41:09

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 20 июня 2021 г. в 13:56:13

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 12 июля 2021 г. в 07:23:57

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 20 июля 2021 г. в 05:04:19

Re: Speed up transaction completion faster after many relations are accessed in a transaction Yura Sokolov <y.sokolov@postgrespro.ru> 6 октября 2021 г. в 16:20:52

Re: Speed up transaction completion faster after many relations are accessed in a transaction Michael Paquier <michael@paquier.xyz> 1 октября 2021 г. в 07:03:09

Re: Speed up transaction completion faster after many relations are accessed in a transaction Michael Paquier <michael@paquier.xyz> 3 декабря 2021 г. в 07:36:45

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 1 января 2022 г. в 01:44:46

Re: Speed up transaction completion faster after many relations are accessed in a transaction Zhihong Yu <zyu@yugabyte.com> 1 января 2022 г. в 02:43:07

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 15 марта 2022 г. в 02:47:17

Re: Speed up transaction completion faster after many relations are accessed in a transaction Yura Sokolov <y.sokolov@postgrespro.ru> 5 апреля 2022 г. в 15:40:52

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 7 апреля 2022 г. в 04:05:19

Re: Speed up transaction completion faster after many relations are accessed in a transaction Jacob Champion <jchampion@timescale.com> 2 августа 2022 г. в 19:04:11

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 3 августа 2022 г. в 03:33:57

Re: Speed up transaction completion faster after many relations are accessed in a transaction Ankit Kumar Pandey <itsankitkp@gmail.com> 3 ноября 2022 г. в 15:42:05

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 15 ноября 2022 г. в 21:03:50

Re: Speed up transaction completion faster after many relations are accessed in a transaction vignesh C <vignesh21@gmail.com> 19 января 2023 г. в 11:25:49

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 24 января 2023 г. в 03:57:37

Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de> 7 февраля 2023 г. в 18:05:36

Re: Speed up transaction completion faster after many relations are accessed in a transaction Amit Langote <amitlangote09@gmail.com> 31 января 2023 г. в 14:07:20

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 10 февраля 2023 г. в 02:51:07

Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi> 5 июля 2023 г. в 09:44:34

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 11 сентября 2023 г. в 12:00:10

Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi> 15 сентября 2023 г. в 10:37:11

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 18 сентября 2023 г. в 04:08:55

Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi> 9 ноября 2023 г. в 16:18:21

Re: Speed up transaction completion faster after many relations are accessed in a transaction vignesh C <vignesh21@gmail.com> 9 января 2024 г. в 06:24:19

Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi> 20 января в 11:43:09

Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de> 20 января в 20:46:19

Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi> 20 января в 22:13:10

Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de> 20 января в 22:31:23

Re: Speed up transaction completion faster after many relations are accessed in a transaction Zhihong Yu <zyu@yugabyte.com> 20 июня 2021 г. в 17:06:47

Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com> 12 июля 2021 г. в 06:55:42

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de> 22 июля 2019 г. в 16:07:00

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2019 г. в 14:41:12

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> 5 апреля 2019 г. в 01:30:32

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 5 апреля 2019 г. в 01:52:36

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com> 5 апреля 2019 г. в 01:38:26

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 25 марта 2019 г. в 11:48:30

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 26 марта 2019 г. в 08:21:20

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> 26 марта 2019 г. в 08:42:33

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 26 марта 2019 г. в 08:55:01

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 26 марта 2019 г. в 10:47:07

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com> 19 марта 2019 г. в 09:20:22

Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com> 19 февраля 2019 г. в 00:05:44

Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com> 19 февраля 2019 г. в 11:57:32

RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 20 февраля 2019 г. в 05:42:41

On Tue, Jul 20, 2021 at 05:04:19PM +1200, David Rowley wrote:
> On Mon, 12 Jul 2021 at 19:23, David Rowley  wrote:
> > I also adjusted the hash seq scan code so that it performs better when
> > faced a non-sparsely populated table.  Previously my benchmark for
> > that case didn't do well [2].
> 
> I was running some select only pgbench tests today on an AMD 3990x
> machine with a large number of processes.
> 
> I saw that LockReleaseAll was coming up on the profile a bit at:

This last update was two months ago, and the patch has not moved
since:
https://commitfest.postgresql.org/34/3220/

Do you have plans to work more on that or perhaps the CF entry should
be withdrawn or RwF'd?
--
Michael

В списке pgsql-hackers по дате отправления

Предыдущее

От: Daniel Gustafsson

Дата: 1 октября 2021 г. в 07:02:46

Сообщение: Re: [PATCH] test/ssl: rework the sslfiles Makefile target

Следующее

От: Michael Paquier

Дата: 1 октября 2021 г. в 07:05:18

Сообщение: Re: pg_receivewal starting position