Re: pgsql: Support partition pruning at execution time - Mailing list pgsql-committers

From Alvaro Herrera
Subject Re: pgsql: Support partition pruning at execution time
Date
Msg-id 20180417192649.kuwcdv7btvdo2iuq@alvherre.pgsql
Whole thread Raw
In response to Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-committers
David Rowley wrote:

> I've made another pass over the nodeAppend.c code and I'm unable to
> see what might cause this, although I did discover a bug where
> first_partial_plan is not set taking into account that some subplans
> may have been pruned away during executor init. The only thing I think
> this would cause is for parallel workers to not properly help out with
> some partial plans if some earlier subplans were pruned. I can see no
> reason for this to have caused this particular issue since the
> first_partial_plan would be 0 with and without the attached fix.

Pushed this.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Update Append's idea of first_partial_plan
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Fix confusion on the padding of GIDs in on commit and abortreco