Hi Rajkumar, Thanks for testing.
On 2017/11/08 15:52, Rajkumar Raghuwanshi wrote: > On Mon, Nov 6, 2017 at 3:31 PM, Amit Langote <langote_amit...@lab.ntt.co.jp> > wrote: > >> Attached updated set of patches, including the fix to make the new pruning >> code handle Boolean partitioning. >> > > Hi Amit, > > I have tried pruning for different values of constraint exclusion GUC > change, not sure exactly how it should behave, but I can see with the > delete statement pruning is not happening when constraint_exclusion is off, > but select is working as expected. Is this expected behaviour? Hmm, the new pruning only works for selects, not DML. The patch also changes get_relation_constraints() to not include the internal partition constraints, but mistakenly does so for all query types, not just select. Will look into it. Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
