Fix ExecRTCheckPerms() inefficiency with many prunable partitions

Edit
Title Fix ExecRTCheckPerms() inefficiency with many prunable partitions
Topic Performance
Created 2021-06-30 13:37:35
Last modified 2022-11-10 04:32:54 (2 weeks, 2 days ago)
Latest email 2022-11-25 11:28:37 (21 hours, 23 minutes ago)
Status
2022-11: Needs review
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
Target version 16
Authors Amit Langote (amitlan)
Reviewers Álvaro Herrera (alvherre), Tom Lane (tgl)Become reviewer
Committer
Links
Emails
ExecRTCheckPerms() and many prunable partitions
First at 2021-06-30 13:33:44 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2022-11-25 11:28:37 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v27-0002-Fix-AclMode-node-support.patch) at 2022-11-25 11:28:37 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v27-0002-Fix-AclMode-node-support.patch) at 2022-11-25 11:28:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v26-0003-Do-not-add-the-NEW-entry-to-view-rule-action-s-r.patch) at 2022-11-21 12:03:43 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Rework-query-relation-permission-checking.patch) at 2022-11-16 11:44:02 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: No)
    Attachment (0002-Simplify-comment-a-little-bit.patch.txt) at 2022-11-10 11:58:01 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v24-0003-Allow-adding-Bitmapsets-as-Nodes-into-plan-trees.patch) at 2022-11-07 07:03:45 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v23-0004-Add-per-result-relation-extraUpdatedCols-to-Modi.patch) at 2022-10-15 06:00:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch) at 2022-10-07 07:31:16 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v22-0004-Add-per-result-relation-extraUpdatedCols-to-Modi.patch) at 2022-10-07 06:49:56 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Rework-query-relation-permission-checking.patch) at 2022-10-07 04:25:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v20-0001-Rework-query-relation-permission-checking.patch) at 2022-10-07 01:04:26 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v19-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch) at 2022-10-06 13:29:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Rework-query-relation-permission-checking.patch) at 2022-10-03 09:10:13 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v17-0001-Rework-query-relation-permission-checking.patch) at 2022-09-07 09:23:06 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v16-0001-Rework-query-relation-permission-checking.patch) at 2022-07-27 03:14:10 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v15-0001-Rework-query-relation-permission-checking.patch) at 2022-07-13 08:00:29 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v14-0001-Rework-query-relation-permission-checking.patch) at 2022-07-06 03:25:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v13-0001-Rework-query-relation-permission-checking.patch) at 2022-04-11 05:41:16 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v12-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch) at 2022-04-06 01:18:48 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch) at 2022-03-31 03:16:02 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-ru.patch) at 2022-03-23 07:03:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-rul.patch) at 2022-03-14 07:36:53 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Rework-query-relation-permission-checking.patch) at 2022-01-17 11:50:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v7-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-rul.patch) at 2022-01-13 06:39:12 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Do-not-add-hidden-OLD-NEW-RTEs-to-stored-view-rul.patch) at 2021-12-20 07:13:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Rework-query-relation-permission-checking.patch) at 2021-09-10 03:22:30 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v4-0001-Rework-query-relation-permission-checking.patch) at 2021-08-26 09:13:33 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v3-0002-Remove-UpdateRangeTableOfViewParse.patch) at 2021-08-20 13:46:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Rework-query-relation-permission-checking.patch) at 2021-07-29 08:40:00 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (0001-Explicitly-track-RT-indexes-of-relations-to-check-pe.patch) at 2021-06-30 13:33:44 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
History
When Who What
2022-11-10 04:32:54 Amit Langote (amitlan) New status: Needs review
2022-11-03 23:44:52 Ian Barwick (barwick) New status: Waiting on Author
2022-10-12 06:58:00 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 16:52:52 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-28 07:44:56 Amit Langote (amitlan) Changed targetversion to 16
2022-07-27 20:02:21 Tom Lane (tgl) Added tgl as reviewer
2022-04-08 14:14:43 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:33:42 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-13 07:45:19 Amit Langote (amitlan) New status: Needs review
2022-01-13 03:10:14 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-03 02:31:57 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-04 16:22:37 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-01 16:30:03 Álvaro Herrera (alvherre) Added alvherre as reviewer
2021-07-29 08:35:55 Amit Langote (amitlan) Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-29 08:35:48 Amit Langote (amitlan) New status: Needs review
2021-07-07 04:40:20 David Rowley (davidrowley) New status: Waiting on Author
2021-06-30 13:38:21 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2021-06-30 13:38:21 Amit Langote (amitlan) Changed targetversion to 15
2021-06-30 13:37:35 Amit Langote (amitlan) Attached mail thread CA+HiwqGjJDmUhDSfv-U2qhKJjt9ST7Xh9JXC_irsAQ1TAUsJYg@mail.gmail.com
2021-06-30 13:37:35 Amit Langote (amitlan) Created patch record
Edit