Re: Performance improvement for joins where outer side is unique

От

Robert Haas

Тема

Дата

2 декабря 2016 г. в 21:09:39

Msg-id

C446D35C-8C9A-4A4A-95A1-C1569F58C697@gmail.com

обсуждение

Ответ на

Re: Performance improvement for joins where outer side is unique (Haribabu Kommi)

Список

pgsql-hackers

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

Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 31 декабря 2014 г. в 13:47:56

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 30 января 2015 г. в 11:37:33

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 3 февраля 2015 г. в 09:25:11

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 27 февраля 2015 г. в 06:23:35

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 10 марта 2015 г. в 06:21:15

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 10 марта 2015 г. в 12:32:31

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 13 марта 2015 г. в 07:35:53

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 14 марта 2015 г. в 01:52:01

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 14 марта 2015 г. в 10:05:36

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 16 марта 2015 г. в 08:30:30

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 18 марта 2015 г. в 08:32:15

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 20 марта 2015 г. в 03:13:29

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 20 марта 2015 г. в 08:11:32

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 22 марта 2015 г. в 06:42:30

Re: Performance improvement for joins where outer side is unique Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> 24 марта 2015 г. в 12:11:56

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 28 марта 2015 г. в 07:35:09

Re: Performance improvement for joins where outer side is unique Alexander Korotkov <a.korotkov@postgrespro.ru> 7 июля 2015 г. в 14:02:31

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 8 июля 2015 г. в 00:29:51

Re: Performance improvement for joins where outer side is unique Uriy Zhuravlev <u.zhuravlev@postgrespro.ru> 6 августа 2015 г. в 13:37:03

Re: Performance improvement for joins where outer side is unique Erik Rijkers <er@xs4all.nl> 6 августа 2015 г. в 14:45:38

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 23 августа 2015 г. в 19:31:53

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 23 августа 2015 г. в 23:36:05

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 24 августа 2015 г. в 00:19:14

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 24 августа 2015 г. в 00:50:19

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 24 августа 2015 г. в 02:29:50

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 25 августа 2015 г. в 05:26:07

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 3 сентября 2015 г. в 16:50:47

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 13 октября 2015 г. в 21:28:31

Re: Performance improvement for joins where outer side is unique Pavel Stehule <pavel.stehule@gmail.com> 14 октября 2015 г. в 05:04:42

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 14 октября 2015 г. в 19:57:52

Re: Performance improvement for joins where outer side is unique Michael Paquier <michael.paquier@gmail.com> 26 августа 2015 г. в 07:44:10

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 16 декабря 2015 г. в 00:27:51

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 16 декабря 2015 г. в 16:02:43

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 16 декабря 2015 г. в 22:40:54

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 17 декабря 2015 г. в 00:17:27

Re: Performance improvement for joins where outer side is unique Simon Riggs <simon@2ndQuadrant.com> 17 декабря 2015 г. в 06:11:44

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 17 декабря 2015 г. в 13:17:32

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 22 января 2016 г. в 16:36:10

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 22 января 2016 г. в 20:42:52

Re: Performance improvement for joins where outer side is unique Alvaro Herrera <alvherre@2ndquadrant.com> 4 марта 2016 г. в 21:43:16

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 6 марта 2016 г. в 00:14:39

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 18 февраля 2016 г. в 09:19:13

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 8 марта 2016 г. в 23:57:15

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 9 марта 2016 г. в 00:19:46

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 9 марта 2016 г. в 00:39:01

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 11 марта 2016 г. в 21:33:04

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 11 марта 2016 г. в 22:43:16

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 12 марта 2016 г. в 10:56:53

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 12 марта 2016 г. в 16:25:38

Re: [HACKERS] Performance improvement for joins where outer side is unique Antonin Houska <ah@cybertec.at> 27 января 2017 г. в 16:14:04

Re: Performance improvement for joins where outer side is unique "David G. Johnston" <david.g.johnston@gmail.com> 12 марта 2016 г. в 14:44:24

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 12 марта 2016 г. в 15:51:48

Re: Performance improvement for joins where outer side is unique "David G. Johnston" <david.g.johnston@gmail.com> 12 марта 2016 г. в 19:37:13

Re: Performance improvement for joins where outer side is unique "David G. Johnston" <david.g.johnston@gmail.com> 12 марта 2016 г. в 20:01:21

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 13 марта 2016 г. в 12:06:42

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 1 апреля 2016 г. в 16:52:50

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 2 апреля 2016 г. в 10:26:42

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 2 апреля 2016 г. в 12:15:06

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 6 апреля 2016 г. в 16:06:06

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 6 апреля 2016 г. в 20:01:27

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2016 г. в 01:07:42

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2016 г. в 18:49:44

Re: Performance improvement for joins where outer side is unique Alvaro Herrera <alvherre@2ndquadrant.com> 7 апреля 2016 г. в 19:02:30

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2016 г. в 19:21:46

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2016 г. в 23:59:46

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 9 апреля 2016 г. в 11:27:25

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 10 апреля 2016 г. в 03:30:42

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 31 октября 2016 г. в 05:37:17

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 24 января 2017 г. в 20:27:36

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 26 января 2017 г. в 14:37:20

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 26 января 2017 г. в 15:54:38

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 26 января 2017 г. в 22:34:17

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 27 января 2017 г. в 00:15:35

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 27 января 2017 г. в 02:39:09

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 27 января 2017 г. в 16:21:52

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 27 января 2017 г. в 19:04:57

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 27 января 2017 г. в 19:44:20

Re: [HACKERS] Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 27 января 2017 г. в 20:15:40

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 27 января 2017 г. в 21:39:17

Re: [HACKERS] Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 27 января 2017 г. в 21:44:28

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 27 января 2017 г. в 22:00:35

Re: [HACKERS] Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 27 января 2017 г. в 22:29:17

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 31 января 2017 г. в 03:10:02

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 13 марта 2017 г. в 21:50:29

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 14 марта 2017 г. в 01:35:30

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 14 марта 2017 г. в 08:37:24

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 27 марта 2017 г. в 01:28:39

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 27 марта 2017 г. в 05:51:03

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 2 апреля 2017 г. в 12:21:06

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 2 апреля 2017 г. в 17:59:17

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 2 апреля 2017 г. в 14:19:09

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 2 апреля 2017 г. в 14:23:29

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 6 апреля 2017 г. в 22:26:35

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2017 г. в 02:29:13

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2017 г. в 02:47:50

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2017 г. в 04:17:52

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2017 г. в 04:41:36

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 7 апреля 2017 г. в 04:59:40

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 8 апреля 2017 г. в 05:23:31

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 9 апреля 2017 г. в 11:53:34

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 31 января 2017 г. в 03:13:56

Re: [HACKERS] Performance improvement for joins where outer side is unique Michael Paquier <michael.paquier@gmail.com> 2 февраля 2017 г. в 06:16:06

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 30 января 2017 г. в 00:34:00

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 30 января 2017 г. в 18:56:07

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 31 января 2017 г. в 00:32:50

Re: [HACKERS] Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 31 января 2017 г. в 00:43:25

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 1 февраля 2017 г. в 14:05:33

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 2 ноября 2016 г. в 02:21:35

Re: Performance improvement for joins where outer side is unique Haribabu Kommi <kommi.haribabu@gmail.com> 2 декабря 2016 г. в 12:47:54

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 2 декабря 2016 г. в 21:09:39

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 2 декабря 2016 г. в 21:27:06

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 19 января 2017 г. в 01:06:14

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 19 января 2017 г. в 02:29:15

Re: [HACKERS] Performance improvement for joins where outer side is unique Antonin Houska <ah@cybertec.at> 25 января 2017 г. в 18:56:21

Re: [HACKERS] Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 26 января 2017 г. в 14:39:26

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 7 апреля 2016 г. в 14:46:36

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 10 апреля 2016 г. в 03:00:25

Re: Performance improvement for joins where outer side is unique David Rowley <david.rowley@2ndquadrant.com> 6 апреля 2016 г. в 21:10:25

Re: Performance improvement for joins where outer side is unique Robert Haas <robertmhaas@gmail.com> 12 марта 2016 г. в 17:17:00

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 12 марта 2016 г. в 17:32:43

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 9 марта 2016 г. в 01:39:25

Re: Performance improvement for joins where outer side is unique Michael Paquier <michael.paquier@gmail.com> 24 декабря 2015 г. в 02:42:21

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 14 марта 2015 г. в 07:55:52

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 25 февраля 2015 г. в 19:39:39

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 27 февраля 2015 г. в 11:30:11

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 26 февраля 2015 г. в 00:16:01

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 26 февраля 2015 г. в 16:36:48

Re: Performance improvement for joins where outer side is unique Tom Lane <tgl@sss.pgh.pa.us> 26 февраля 2015 г. в 17:34:36

Re: Performance improvement for joins where outer side is unique Tomas Vondra <tomas.vondra@2ndquadrant.com> 26 февраля 2015 г. в 17:49:01

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 4 марта 2015 г. в 09:00:39

Re: Performance improvement for joins where outer side is unique David Rowley <dgrowleyml@gmail.com> 4 марта 2015 г. в 09:04:09

On Dec 2, 2016, at 7:47 AM, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:

On Wed, Nov 2, 2016 at 1:21 PM, David Rowley <david.rowley@2ndquadrant.com> wrote:
On 31 October 2016 at 18:37, David Rowley <david.rowley@2ndquadrant.com> wrote:
> I've rebased the changes I made to address this back in April to current master.

Please note that I went ahead and marked this as "Ready for
committer". It was previously marked as such in a previous commitfest.
The changes made since last version was based on feedback from Tom.

If anyone thinks this is not correct then please mark as "Ready for review".

Patch still applies fine to HEAD.
Moved to next CF with "ready for committer" status.

Tom, are you picking this up?

...Robert

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

Предыдущее

От: Tom Lane

Дата: 2 декабря 2016 г. в 21:07:50

Сообщение: Re: [COMMITTERS] pgsql: Add max_parallel_workers GUC.

Следующее

От: Tom Lane

Дата: 2 декабря 2016 г. в 21:27:06

Сообщение: Re: Performance improvement for joins where outer side is unique