Re: generic plans and "initial" pruning

From:	Amit Langote <amitlangote09(at)gmail(dot)com>
To:	Jacob Champion <jchampion(at)timescale(dot)com>
Cc:	Zhihong Yu <zyu(at)yugabyte(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: generic plans and "initial" pruning
Date:	2022-07-13 06:40:10
Message-ID:	CA+HiwqERbYQAViE1TiVxW_R7Qt-B+u2k=koKRHKFV=Jw8tZQCg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-12-25 03:36:00 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎  2021-12-28 13:12:00 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>   2021-12-31 02:26:11 from Amit Langote <amitlangote09(at)gmail(dot)com>    2022-01-06 06:44:33 from Amul Sul <sulamul(at)gmail(dot)com>     2022-01-14 14:10:43 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎      2022-01-18 01:32:57 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎  2022-01-11 16:22:23 from Robert Haas <robertmhaas(at)gmail(dot)com>   2022-01-12 14:31:53 from Amit Langote <amitlangote09(at)gmail(dot)com>    2022-01-12 18:20:15 from Robert Haas <robertmhaas(at)gmail(dot)com>     2022-02-10 08:13:52 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎      2022-02-10 22:01:52 from Robert Haas <robertmhaas(at)gmail(dot)com>       2022-03-07 14:18:33 from Amit Langote <amitlangote09(at)gmail(dot)com>        2022-03-11 14:35:37 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎         2022-03-11 15:06:34 from Amit Langote <amitlangote09(at)gmail(dot)com>         2022-03-14 18:42:19 from Robert Haas <robertmhaas(at)gmail(dot)com>          2022-03-14 19:38:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2022-03-14 20:06:22 from Robert Haas <robertmhaas(at)gmail(dot)com>            2022-03-15 06:19:00 from Amit Langote <amitlangote09(at)gmail(dot)com>             2022-03-22 12:44:57 from Amit Langote <amitlangote09(at)gmail(dot)com>              2022-03-28 07:17:00 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎               2022-03-28 07:28:46 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                2022-03-31 03:25:20 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                 2022-03-31 09:56:09 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2022-03-31 11:11:54 from Amit Langote <amitlangote09(at)gmail(dot)com>                 2022-04-01 01:31:54 from David Rowley <dgrowleyml(at)gmail(dot)com>                  2022-04-01 03:09:35 from Amit Langote <amitlangote09(at)gmail(dot)com>                   2022-04-01 03:45:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2022-04-01 07:01:18 from Amit Langote <amitlangote09(at)gmail(dot)com>                   2022-04-01 04:08:27 from David Rowley <dgrowleyml(at)gmail(dot)com>                    2022-04-01 06:58:13 from Amit Langote <amitlangote09(at)gmail(dot)com>                     2022-04-01 08:19:49 from David Rowley <dgrowleyml(at)gmail(dot)com>                      2022-04-01 08:36:49 from Amit Langote <amitlangote09(at)gmail(dot)com>                       2022-04-06 07:20:46 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                        2022-04-07 08:27:50 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                         2022-04-07 12:41:13 from David Rowley <dgrowleyml(at)gmail(dot)com>                          2022-04-08 05:49:39 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                           2022-04-08 11:15:53 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                            2022-04-08 11:45:37 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                             2022-04-11 03:05:19 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                              2022-04-11 03:58:23 from Zhihong Yu <zyu(at)yugabyte(dot)com>                               2022-05-27 08:09:46 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                2022-05-27 20:08:39 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                2022-07-05 17:43:21 from Jacob Champion <jchampion(at)timescale(dot)com>                                 2022-07-06 02:37:57 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                  2022-07-13 06:40:10 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                   2022-07-13 07:03:51 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                    2022-07-27 03:00:57 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                     2022-07-27 16:27:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                                      2022-07-29 04:20:37 from Amit Langote <amitlangote09(at)gmail(dot)com>                                       2022-07-29 04:55:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2022-07-29 12:22:26 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2022-07-29 15:04:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2022-07-29 15:56:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                           2022-07-29 16:47:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2022-07-29 16:55:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2022-10-12 07:36:15 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                        2022-10-17 09:29:48 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                         2022-10-27 02:41:55 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                          2022-11-08 06:22:32 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                           2022-11-30 18:12:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                            2022-12-01 07:59:25 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                             2022-12-01 11:21:06 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2022-12-01 12:43:28 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                               2022-12-02 10:40:42 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                2022-12-05 03:00:01 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                 2022-12-05 06:08:09 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                  2022-12-06 19:00:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                   2022-12-09 08:26:59 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                    2022-12-09 09:52:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                     2022-12-09 10:34:21 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                      2022-12-09 10:49:47 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                       2022-12-09 11:02:05 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                        2022-12-09 11:37:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2022-12-12 11:19:19 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                          2022-12-12 17:24:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                           2022-12-14 08:35:47 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                            2022-12-16 02:33:53 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                             2022-12-21 10:18:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                              2022-12-21 10:47:24 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                              2022-12-21 15:18:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                               2023-01-19 19:39:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2023-01-20 03:13:53 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                 2023-01-20 03:31:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2023-01-20 03:52:07 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                   2023-01-20 03:58:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2023-01-20 07:19:08 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                   2023-01-27 07:01:05 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                    2023-02-02 14:49:58 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                     2023-02-03 13:01:09 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                      2023-02-07 18:08:55 from Andres Freund <andres(at)anarazel(dot)de>                                                                       2023-02-08 10:31:30 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                        2023-03-02 13:52:53 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                         2023-03-14 10:07:41 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                          2023-03-22 12:48:49 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                           2023-03-27 08:18:20 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                            2023-03-27 14:00:38 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                             2023-04-03 21:41:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                              2023-04-04 13:29:12 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                               2023-04-05 23:23:31 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                2023-06-08 14:23:21 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                 2023-07-03 13:27:22 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                                                  2023-07-06 14:29:10 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                   2023-07-13 12:58:38 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                    2023-07-17 16:32:51 from Thom Brown <thom(at)linux(dot)com>                                                                                     2023-07-18 07:26:35 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                      2023-07-18 08:36:55 from Thom Brown <thom(at)linux(dot)com>                                                                                      2023-08-02 13:39:45 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                       2023-08-03 08:37:39 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                        2023-08-07 15:36:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                         2023-08-07 15:44:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                          2023-08-07 16:25:52 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                         2023-08-08 14:32:07 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                          2023-08-08 16:05:26 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                           2023-08-11 05:31:03 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                            2023-08-11 13:50:26 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                             2023-08-28 13:43:41 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                              2023-09-05 07:13:09 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                               2023-09-05 14:41:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                2023-09-06 09:12:28 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                 2023-09-06 14:20:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                  2023-09-25 12:57:48 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                   2023-09-26 13:06:12 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                    2023-09-28 08:26:27 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                     2023-11-20 04:29:53 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                      2023-12-06 18:52:59 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                      2024-01-05 10:46:27 from vignesh C <vignesh21(at)gmail(dot)com>                                                                                                       2024-03-31 05:03:31 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                                                                                        2024-04-08 08:39:02 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                      2024-06-19 17:09:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                                       2024-08-12 12:54:16 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                        2024-08-14 19:23:05 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                         2024-08-15 12:57:40 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                          2024-08-15 15:34:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                           2024-08-16 12:35:56 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                            2024-08-19 16:39:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                             2024-08-19 16:54:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                              2024-08-19 17:38:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                               2024-08-19 17:52:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                2024-08-19 18:20:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                 2024-08-20 13:14:58 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                             2024-08-20 13:00:38 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                              2024-08-20 14:53:45 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                               2024-08-21 12:45:24 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                                2024-08-21 13:10:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                 2024-08-23 12:48:27 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                                  2024-08-29 13:34:17 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                   2024-08-31 12:30:34 from Junwang Zhao <zhjwpku(at)gmail(dot)com>                                                                                                                    2024-09-02 08:19:39 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                                     2024-09-05 09:55:47 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                   2024-09-17 12:57:03 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                    2024-09-19 08:39:51 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                     2024-09-19 12:10:04 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                      2024-09-20 08:10:03 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                                                                       2024-10-10 20:15:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                        2024-10-11 07:30:23 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                                                                         2024-10-15 14:38:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                          2024-10-15 15:22:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                         2024-10-25 12:30:24 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                                2024-05-19 00:39:24 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                                 2024-05-19 01:27:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2024-05-19 01:51:51 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                                 2024-05-20 12:13:21 from Amit Langote <amitlangote09(at)gmail(dot)com>                 2022-04-03 11:21:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2022-04-04 12:55:54 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                   2022-04-05 02:29:49 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                    2022-04-05 10:00:35 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                     2022-04-05 12:56:02 from Amit Langote <amitlangote09(at)gmail(dot)com>      2022-02-11 01:29:35 from Andres Freund <andres(at)anarazel(dot)de>       2022-02-28 06:04:14 from Amit Langote <amitlangote09(at)gmail(dot)com>     2022-02-13 21:55:16 from David Rowley <dgrowleyml(at)gmail(dot)com>      2022-02-14 20:17:48 from Robert Haas <robertmhaas(at)gmail(dot)com>   2022-01-18 07:44:48 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>    2022-01-18 08:10:22 from Amit Langote <amitlangote09(at)gmail(dot)com>     2022-01-18 10:28:20 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>      2022-01-19 08:30:59 from Amit Langote <amitlangote09(at)gmail(dot)com>       2022-01-19 11:16:44 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>     2022-01-18 14:53:05 from Robert Haas <robertmhaas(at)gmail(dot)com>      2022-01-19 08:31:45 from Amit Langote <amitlangote09(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v18-0002-Optimize-AcquireExecutorLocks-by-locking-only-un.patch	application/octet-stream	81.4 KB
v18-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch	application/octet-stream	17.8 KB

In response to

• Re: generic plans and "initial" pruning at 2022-07-06 02:37:57 from Amit Langote

Responses

• Re: generic plans and "initial" pruning at 2022-07-13 07:03:51 from Amit Langote

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	vignesh C	2022-07-13 06:52:06	Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.
Previous Message	Peter Eisentraut	2022-07-13 06:39:45	Re: [RFC] building postgres with meson -v9