Re: Removing unneeded self joins

From:	Tender Wang <tndrwang(at)gmail(dot)com>
To:	Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc:	Andrei Lepikhov <lepihov(at)gmail(dot)com>, Richard Guo <guofenglinux(at)gmail(dot)com>, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>, Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Alexander Lakhin <exclusion(at)gmail(dot)com>, "Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>, Michał Kłeczek <michal(at)kleczek(dot)org>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Subject:	Re: Removing unneeded self joins
Date:	2025-04-06 04:02:38
Message-ID:	CAHewXN=+ghd6O6im46q7j2u6c3H6vkXtXmF=_v4CfGSnjje8PA@mail.gmail.com
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>                                                                               2024-04-30 06:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                2024-04-30 08:53:20 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                2024-04-30 10:20:54 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                 2024-05-01 11:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                  2024-05-01 11:59:58 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                   2024-05-02 09:44:54 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                    2024-05-02 10:07:54 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                     2024-05-02 13:14:20 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                                                                      2024-05-02 23:04:40 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                       2024-05-02 23:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                        2024-05-03 03:19:58 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                        2024-05-03 08:56:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                         2024-05-03 13:55:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                          2024-05-05 02:45:47 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                           2024-05-06 14:44:33 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                            2024-05-06 15:17:08 from Bruce Momjian <bruce(at)momjian(dot)us>                                                                                            2024-05-06 15:54:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                             2024-05-06 19:08:40 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                             2024-06-17 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                                              2024-07-02 00:25:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                                               2024-07-09 06:06:10 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                2024-07-11 07:43:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                                                 2024-07-12 03:05:15 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                  2024-07-12 10:30:35 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                   2024-07-12 13:59:13 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                    2024-07-15 05:31:33 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                                                     2024-07-15 06:08:43 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                      2024-07-15 07:35:06 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                                                       2024-07-15 08:31:08 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                        2024-07-16 14:26:40 from Вардан Погосян <vardan(dot)pogosyn(at)yandex(dot)ru> 📎                                                                                                         2024-07-16 14:30:47 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                          2024-07-18 06:26:49 from Pogosyan Vardan <vardan(dot)pogosyn(at)yandex(dot)ru>                                                                                              2024-07-03 03:39:09 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                               2024-07-04 02:14:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                                                2024-07-04 03:04:19 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                 2024-07-04 08:40:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                                                  2024-07-08 09:10:57 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                             2024-07-17 00:45:07 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                              2024-07-19 08:30:07 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                                                               2024-07-20 11:38:48 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                2024-07-22 02:13:49 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                2024-07-24 11:07:47 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                                                                 2024-10-08 03:54:02 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                  2024-10-28 09:32:50 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                  2024-10-28 21:18:27 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                2024-12-09 06:03:10 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                 2024-12-11 09:02:32 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                 2024-12-23 08:25:32 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                  2025-01-10 03:13:52 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                   2025-01-31 04:57:46 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                    2025-02-09 11:41:10 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                     2025-02-10 05:19:49 from Andrei Lepikhov <lepihov(at)gmail(dot)com> 📎                                                                                                      2025-02-10 19:58:54 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                       2025-02-11 15:31:33 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                                                                        2025-02-12 23:00:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                         2025-02-15 09:19:42 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                          2025-02-18 07:24:02 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                                                          2025-02-23 17:02:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                           2025-02-23 21:15:35 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                            2025-02-23 22:12:36 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                             2025-02-24 10:57:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                              2025-02-24 12:22:35 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                               2025-02-26 12:14:31 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                                2025-03-07 06:03:53 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                              2025-02-26 12:12:30 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                          2025-03-21 17:06:13 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> 📎                                                                                                           2025-04-03 16:02:16 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                            2025-04-04 02:53:54 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                                                                             2025-04-04 08:35:39 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                                                                                                              2025-04-05 10:09:23 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                                               2025-04-05 21:01:57 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                                                               2025-04-06 04:02:38 from Tender Wang <tndrwang(at)gmail(dot)com> 📎                                                                                                                2025-04-06 11:23:24 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                                                                                 2025-04-06 11:42:01 from Tender Wang <tndrwang(at)gmail(dot)com>                                                                                                                  2025-04-06 11:49:54 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                                   2025-04-06 13:09:22 from Tender Wang <tndrwang(at)gmail(dot)com>                                                                                                                   2025-04-06 14:41:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                    2025-04-06 16:46:36 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                                                     2025-04-07 03:12:24 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                                                                                      2025-04-07 13:11:55 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                            2024-05-06 16:01:39 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                             2024-05-06 16:24:41 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                              2024-05-06 17:08:35 from Bruce Momjian <bruce(at)momjian(dot)us>                                                                                            2024-05-06 19:27:28 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                             2024-05-06 19:59:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                              2024-06-13 03:45:38 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                               2024-06-16 16:42:26 from Alexander Korotkov <aekorotkov(at)gmail(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
0001-Put-enable_self_join_elimination-into-postgresql.con.patch	text/plain	757 bytes

In response to

• Re: Removing unneeded self joins at 2025-04-05 10:09:23 from Alexander Korotkov

Responses

• Re: Removing unneeded self joins at 2025-04-06 11:23:24 from Daniel Gustafsson

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Álvaro Herrera	2025-04-06 04:56:30	Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Previous Message	Andres Freund	2025-04-06 02:32:40	Re: rename pg_log_standby_snapshot