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

От

Alvaro Herrera

Тема

Дата

25 сентября 2019 г. в 21:08:05

Msg-id

20190925210805.GA26655@alvherre.pgsql

обсуждение

Ответ на

RE: Speed up transaction completion faster after many relations areaccessed in a transaction (Tsunakawa, Takayuki)

Список

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 2019-Sep-03, Tsunakawa, Takayuki wrote:

> From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]
> > Hmm ... is this patch rejected, or is somebody still trying to get it to
> > committable state?  David, you're listed as committer.
> 
> I don't think it's rejected.  It would be a pity (mottainai) to refuse
> this, because it provides significant speedup despite its simple
> modification.

I don't necessarily disagree with your argumentation, but Travis is
complaining thusly:

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O2 -Wall -Werror -I../../../../src/include -I/usr/include/x86_64-linux-gnu -D_GNU_SOURCE   -c -o lock.o lock.c
1840lock.c:486:1: error: conflicting types for ‘TryShrinkLocalLockHash’
1841 TryShrinkLocalLockHash(long numLocksHeld)
1842 ^
1843lock.c:351:20: note: previous declaration of ‘TryShrinkLocalLockHash’ was here
1844 static inline void TryShrinkLocalLockHash(void);
1845                    ^
1846: recipe for target 'lock.o' failed

Please fix.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее

От: Tom Lane

Дата: 25 сентября 2019 г. в 21:02:48

Сообщение: Re: benchmarking Flex practices

Следующее

От: Petr Jelinek

Дата: 25 сентября 2019 г. в 21:14:18

Сообщение: Re: DROP SUBSCRIPTION with no slot