Re: ExecRTCheckPerms() and many prunable partitions

From:	Amit Langote <amitlangote09(at)gmail(dot)com>
To:	David Rowley <dgrowleyml(at)gmail(dot)com>
Cc:	Greg Stark <stark(at)mit(dot)edu>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: ExecRTCheckPerms() and many prunable partitions
Date:	2022-07-27 03:14:10
Message-ID:	CA+HiwqGKnrnzZQB8xwW-fLVUbURQmvY9rBSyJ6arR2YO7KPFVA@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-06-30 13:33:44 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎  2021-06-30 14:33:46 from David Rowley <dgrowleyml(at)gmail(dot)com>   2021-06-30 14:58:23 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-06-30 22:51:51 from David Rowley <dgrowleyml(at)gmail(dot)com>  2021-07-01 15:45:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2021-07-02 00:40:47 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-07-07 04:41:13 from David Rowley <dgrowleyml(at)gmail(dot)com>     2021-07-07 07:12:49 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-07-29 08:40:00 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎     2021-08-20 13:46:17 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎      2021-08-26 09:13:33 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎       2021-09-06 19:35:20 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>        2021-09-10 03:22:30 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎         2021-12-20 07:13:04 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎          2022-01-13 03:10:05 from Julien Rouhaud <rjuju123(at)gmail(dot)com>           2022-01-13 06:39:12 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎            2022-01-17 11:50:42 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎             2022-01-17 15:45:06 from Zhihong Yu <zyu(at)yugabyte(dot)com>              2022-03-14 07:36:53 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎               2022-03-23 07:03:04 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                2022-03-23 09:49:53 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                2022-03-23 21:02:10 from Zhihong Yu <zyu(at)yugabyte(dot)com>                2022-03-24 19:46:09 from David Rowley <dgrowleyml(at)gmail(dot)com>                 2022-03-31 03:16:02 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                  2022-04-05 14:26:58 from Greg Stark <stark(at)mit(dot)edu>                   2022-04-05 20:21:40 from David Rowley <dgrowleyml(at)gmail(dot)com>                    2022-04-06 01:18:48 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                     2022-04-11 05:41:16 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                      2022-07-06 03:25:42 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                       2022-07-13 08:00:29 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                        2022-07-27 03:14:10 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                         2022-07-27 21:04:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2022-07-27 21:18:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2022-10-04 03:45:30 from Amit Langote <amitlangote09(at)gmail(dot)com>                            2022-10-04 03:54:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2022-10-04 04:11:08 from Amit Langote <amitlangote09(at)gmail(dot)com>                              2022-10-06 13:29:46 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                               2022-10-07 01:04:26 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                2022-10-07 04:25:42 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                 2022-10-07 06:49:56 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                  2022-10-07 07:31:16 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                   2022-10-15 06:00:58 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                    2022-11-03 23:46:02 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                     2022-11-07 07:03:45 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                      2022-11-10 11:58:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                       2022-11-16 11:44:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                       2022-11-21 12:03:43 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                        2022-11-21 12:46:03 from Amit Langote <amitlangote09(at)gmail(dot)com>                                        2022-11-25 11:28:37 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                         2022-11-29 09:27:08 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                          2022-11-29 13:37:56 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                           2022-11-29 18:04:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                            2022-11-30 02:56:54 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                             2022-11-30 06:45:53 from Amit Langote <amitlangote09(at)gmail(dot)com>                                           2022-11-30 08:32:15 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                            2022-12-02 07:41:11 from Amit Langote <amitlangote09(at)gmail(dot)com>                                             2022-12-02 07:44:05 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                             2022-12-02 09:59:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2022-12-02 11:13:28 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                               2022-12-05 03:09:27 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                2022-12-06 15:19:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                 2022-12-07 07:01:18 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                  2022-12-07 08:47:13 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                   2022-12-07 11:44:15 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                 2022-12-07 10:42:59 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                  2022-12-07 10:50:11 from Amit Langote <amitlangote09(at)gmail(dot)com>                                           2022-12-01 10:49:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                           2022-12-10 20:17:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                            2022-12-11 09:25:48 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                             2022-12-11 14:21:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                             2022-12-12 06:23:22 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                              2022-12-21 19:44:11 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                               2023-01-05 21:12:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                2023-01-05 21:25:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                              2023-01-17 10:26:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                               2023-01-19 11:16:16 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                2023-01-19 12:25:20 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                             2023-02-17 12:02:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                              2023-02-17 12:05:58 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2023-02-20 07:56:22 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                               2023-02-20 15:19:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                2023-02-20 15:40:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                 2023-02-21 07:12:14 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                  2023-06-28 07:30:54 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                   2023-06-30 06:54:38 from Amit Langote <amitlangote09(at)gmail(dot)com>                                           2023-02-12 23:37:11 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                            2023-02-13 08:14:44 from Amit Langote <amitlangote09(at)gmail(dot)com>                                             2023-02-13 17:01:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                              2023-02-14 05:44:59 from Amit Langote <amitlangote09(at)gmail(dot)com>                               2022-10-12 13:49:56 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                                2022-10-13 08:14:30 from Amit Langote <amitlangote09(at)gmail(dot)com>                               2022-11-10 12:19:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                2022-11-11 16:46:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2022-11-14 07:32:43 from Amit Langote <amitlangote09(at)gmail(dot)com>                          2022-09-07 09:23:06 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                           2022-10-02 17:10:36 from Andres Freund <andres(at)anarazel(dot)de>                            2022-10-03 09:10:13 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v16-0001-Rework-query-relation-permission-checking.patch	application/octet-stream	149.7 KB
v16-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch	application/octet-stream	123.0 KB

In response to

• Re: ExecRTCheckPerms() and many prunable partitions at 2022-07-13 08:00:29 from Amit Langote

Responses

• Re: ExecRTCheckPerms() and many prunable partitions at 2022-07-27 21:04:15 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Richard Guo	2022-07-27 03:16:36	Re: Add proper planner support for ORDER BY / DISTINCT aggregates
Previous Message	Amit Langote	2022-07-27 03:00:57	Re: generic plans and "initial" pruning