Re: Removing unneeded self joins

From:	Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru>
To:	PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Removing unneeded self joins
Date:	2018-10-18 12:47:09
Message-ID:	e34fc4cc-68d0-8ebf-9376-a8089a92ec2d@postgrespro.ru
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-05-16 15:43:33 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎  2018-05-16 16:08:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2018-05-16 16:26:48 from Robert Haas <robertmhaas(at)gmail(dot)com>    2018-05-16 18:58:40 from Andres Freund <andres(at)anarazel(dot)de>     2018-05-16 20:36:51 from "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>    2018-05-16 20:04:14 from Simon Riggs <simon(at)2ndquadrant(dot)com>     2018-05-16 20:10:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2018-05-16 20:44:27 from Simon Riggs <simon(at)2ndquadrant(dot)com>       2018-05-16 20:48:58 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>        2018-05-16 22:02:22 from Andres Freund <andres(at)anarazel(dot)de>        2018-05-16 22:13:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2018-05-16 22:24:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>          2018-05-16 22:55:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2018-05-16 23:00:53 from Andres Freund <andres(at)anarazel(dot)de>            2018-05-17 01:38:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>             2018-05-17 02:11:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2018-05-17 02:19:34 from Andres Freund <andres(at)anarazel(dot)de>               2018-05-17 08:15:51 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>           2018-05-17 01:33:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>         2018-05-18 19:47:42 from Robert Haas <robertmhaas(at)gmail(dot)com>  2018-05-16 20:45:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>   2018-05-16 21:31:37 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru>   2018-06-25 15:26:28 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎    2018-07-27 12:26:03 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎     2018-07-29 10:42:32 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>      2018-08-03 16:49:47 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎       2018-10-08 14:52:21 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎        2018-10-18 12:47:09 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎         2018-11-08 05:59:19 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>          2018-11-21 12:54:20 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎           2018-12-24 16:28:01 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎            2019-02-22 00:25:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎             2019-02-28 14:09:34 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎              2019-03-14 11:21:29 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>               2019-03-20 12:20:35 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎                2019-03-20 22:54:49 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                 2019-03-22 14:39:40 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎                  2019-03-22 15:13:09 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                   2019-03-25 04:07:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                    2019-03-25 13:45:02 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru>                     2019-03-25 15:13:24 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎                      2019-05-13 16:21:24 from Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> 📎                       2019-06-27 06:42:05 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                        2019-08-01 23:54:47 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                         2019-08-05 11:24:52 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                          2019-08-07 16:23:34 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                           2019-09-27 16:38:00 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                            2019-09-30 08:29:44 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                             2019-11-05 18:20:28 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                              2020-01-28 04:10:07 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                               2020-04-01 15:34:54 from David Steele <david(at)pgmasters(dot)net>                                2020-04-03 04:43:41 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                 2020-09-23 04:23:27 from David Rowley <dgrowleyml(at)gmail(dot)com>                                  2020-10-31 09:26:29 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                   2020-11-27 09:19:20 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                                   2020-11-27 16:49:57 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                    2020-11-28 17:21:17 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                     2020-11-29 17:10:55 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                      2020-11-30 05:50:57 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                       2021-01-07 14:08:03 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                        2021-01-11 04:07:15 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                         2021-03-12 09:05:06 from Hywel Carver <hywel(at)skillerwhale(dot)com>                                          2021-05-07 07:23:00 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                           2021-05-27 06:51:23 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                            2021-07-15 12:05:23 from vignesh C <vignesh21(at)gmail(dot)com>                                          2021-06-30 11:21:15 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                           2021-06-30 15:55:21 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                                            2021-07-01 05:20:24 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                            2021-07-01 06:37:46 from Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>                                             2022-02-28 22:03:25 from Greg Stark <stark(at)mit(dot)edu>                                              2022-03-04 10:47:47 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                               2022-03-22 00:58:39 from Andres Freund <andres(at)anarazel(dot)de>                                                2022-03-24 05:21:54 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                 2022-04-01 15:27:56 from Greg Stark <stark(at)mit(dot)edu>                                                  2022-04-04 08:27:45 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                  2022-05-13 05:07:47 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                   2022-05-17 14:14:46 from Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>                                                    2022-05-19 10:48:18 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                     2022-05-19 11:47:36 from Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>                                                      2022-06-30 14:11:51 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                       2022-07-04 13:49:59 from Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>                                                        2022-07-04 14:16:31 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                         2022-08-26 22:02:16 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                          2022-08-28 23:39:09 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                           2022-08-29 05:05:29 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                            2022-10-05 12:25:18 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                             2022-12-06 18:46:43 from Andres Freund <andres(at)anarazel(dot)de>                                                              2022-12-16 06:45:30 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                               2023-03-06 05:30:03 from Michał Kłeczek <michal(at)kleczek(dot)org>                                                                2023-04-03 20:30:52 from "Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>                                                                 2023-05-25 09:40:35 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                 2023-06-30 10:50:19 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                  2023-07-05 14:28:59 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                   2023-09-12 11:49:05 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                    2023-10-04 00:12:02 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                     2023-10-04 06:55:59 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                      2023-10-04 07:34:15 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                       2023-10-05 07:20:21 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                       2023-10-05 09:17:08 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                        2023-10-10 19:29:58 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                                                                         2023-10-11 03:51:26 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                        2023-10-12 11:32:27 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                         2023-10-13 02:55:13 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                          2023-10-13 08:56:37 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                                                                           2023-10-13 09:03:50 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                            2023-10-13 09:42:35 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                                                                         2023-10-16 08:28:13 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                          2023-10-18 18:50:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                           2023-10-19 03:16:05 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                            2023-10-21 22:01:49 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                             2023-10-23 03:43:13 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                              2023-10-23 09:47:53 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                               2023-10-23 11:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                2023-10-23 11:29:15 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                 2023-12-29 05:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                  2023-12-29 09:58:11 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                   2023-12-29 11:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                    2024-01-08 20:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                     2024-01-08 20:20:36 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                      2024-01-08 22:09:49 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                       2024-01-09 04:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                        2024-01-09 06:08:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                         2024-01-09 08:03:28 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                       2024-02-18 13:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                        2024-02-18 15:04:17 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                         2024-02-18 16:18:21 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                          2024-02-18 18:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                          2024-02-19 05:24:09 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                           2024-02-21 07:26:57 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                                                                            2024-02-21 07:59:45 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                            2024-02-22 08:51:19 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                             2024-02-23 22:36:59 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                              2024-02-24 05:12:05 from Noah Misch <noah(at)leadboat(dot)com>                                                                                               2024-02-24 11:02:01 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                2024-02-24 17:20:22 from Noah Misch <noah(at)leadboat(dot)com>                                                       2022-08-26 12:22:08 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                           2021-07-01 22:56:37 from Hywel Carver <hywel(at)skillerwhale(dot)com>                                            2021-07-05 13:20:01 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                             2021-07-06 10:49:54 from Hywel Carver <hywel(at)skillerwhale(dot)com>                                              2021-07-15 14:49:11 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                               2021-07-15 15:25:56 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                2021-07-15 19:28:13 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                 2021-07-27 05:34:30 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                               2022-03-01 00:09:49 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> 📎                                                2022-03-01 02:45:19 from Greg Stark <stark(at)mit(dot)edu>  2018-05-16 21:41:25 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>   2018-05-16 22:37:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2018-05-16 22:44:50 from Andres Freund <andres(at)anarazel(dot)de>    2018-05-16 22:45:45 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
remove-self-join-v6.patch	text/x-patch	52.2 KB

In response to

• Re: Removing unneeded self joins at 2018-10-08 14:52:21 from Alexander Kuzmenkov

Responses

• Re: Removing unneeded self joins at 2018-11-08 05:59:19 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Ildar Musin	2018-10-18 14:01:04	Possibly redundant context switch in postgres_fdw
Previous Message	Andrew Dunstan	2018-10-18 12:31:11	lowering pg_regress privileges on Windows