Improve ExecFindInitialMatchingSubPlans's subplan renumbering logic.
Tom Lane <tgl@sss.pgh.pa.us>
Improve ExecFindInitialMatchingSubPlans's subplan renumbering logic. We don't need two passes if we scan child partitions before parents, as that way the children's present_parts are up to date before they're needed. I (tgl) think there's actually a bug being fixed here, for the case of an intermediate partitioned table with no direct leaf children, but haven't attempted to construct a test case to prove it. David Rowley Discussion: https://postgr.es/m/CAKJS1f-6GODRNgEtdPxCnAPme2h2hTztB6LmtfdmcYAAOE0kQg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/execPartition.c | modified | +22 −46 |
Discussion
- why partition pruning doesn't work? 72 messages · 2018-06-01 → 2018-07-18