pgsql: Improve ExecFindInitialMatchingSubPlans's subplan renumbering lo

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improve ExecFindInitialMatchingSubPlans's subplan renumbering lo
Date: 2018-06-11 21:36:03
Message-ID: E1fSUTr-00054L-I2@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/69025c5a07a10c842bfbcb62d4af1221e5ce7e85

Modified Files
--------------
src/backend/executor/execPartition.c | 68 ++++++++++++------------------------
1 file changed, 22 insertions(+), 46 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2018-06-11 21:47:27 Re: pgsql: Fix and document lock handling for in-memory replication slot da
Previous Message Peter Eisentraut 2018-06-11 21:22:53 pgsql: Adjust error message