| 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 |
| Message-ID: | b8c77817-5071-e829-8967-eaa5308102a1@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
Thanks,
Amit
| 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 |
| 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 |