Re: path toward faster partition pruning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
Cc: Beena Emerson <memissemerson(at)gmail(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: path toward faster partition pruning
Date: 2017-10-30 06:50:25
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2017/10/30 14:55, Amit Langote wrote:
> Fixed in the attached updated patch, along with a new test in 0001 to
> cover this case. Also, made a few tweaks to 0003 and 0005 (moved some
> code from the former to the latter) around the handling of ScalarArrayOpExprs.

Sorry, I'd forgotten to include some changes.

In the previous versions, RT index of the table needed to be passed to
partition.c, which I realized is no longer needed, so I removed that
requirement from the interface. As a result, patches 0002 and 0003 have
changed in this version.


Attachment Content-Type Size
0001-Add-new-tests-for-partition-pruning-v8.patch text/plain 45.8 KB
0002-Planner-side-changes-for-partition-pruning-v8.patch text/plain 37.2 KB
0003-Implement-get_partitions_from_clauses-v8.patch text/plain 33.4 KB
0004-Some-interface-changes-for-partition_bound_-cmp-bsea-v8.patch text/plain 10.1 KB
0005-Implement-get_partitions_for_keys-v8.patch text/plain 21.5 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2017-10-30 07:26:33 Re: Parallel worker error
Previous Message Michael Paquier 2017-10-30 06:29:00 Re: Reading timeline from pg_control on replication slave