RE: Speed up transaction completion faster after many relations areaccessed in a transaction

От

Tsunakawa, Takayuki

Тема

Дата

5 апреля 2019 г. в 01:52:36

Msg-id

0A3221C70F24FB45833433255569204D1FBEFD91@G01JPEXMBYT05

обсуждение

Ответ на

Re: Speed up transaction completion faster after many relations areaccessed in a transaction (Amit Langote)

Список

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

Hi Amit-san, Imai-snan,

From: Amit Langote [mailto:Langote_Amit_f8@lab.ntt.co.jp]
> I was able to detect it as follows.
> plan_cache_mode = auto
> 
>    HEAD: 1915 tps
> Patched: 2394 tps
> 
> plan_cache_mode = custom (non-problematic: generic plan is never created)
> 
>    HEAD: 2402 tps
> Patched: 2393 tps

Thanks a lot for very quick confirmation.  I'm relieved to still see the good results.


Regards
Takayuki Tsunakawa

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

Предыдущее

От: Michael Paquier

Дата: 5 апреля 2019 г. в 01:43:41

Сообщение: Re: fix the spelling mistakes of comments

Следующее

От: Imai, Yoshikazu

Дата: 5 апреля 2019 г. в 01:54:23

Сообщение: RE: Speed up transaction completion faster after many relations areaccessed in a transaction