Re: path toward faster partition pruning

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>

To: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>

Cc: Beena Emerson <memissemerson@gmail.com>, David Rowley <david.rowley@2ndquadrant.com>, Dilip Kumar <dilipbalaut@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2017-10-30T06:50:25Z

Lists: pgsql-hackers

Attachments

0001-Add-new-tests-for-partition-pruning-v8.patch (text/plain) patch v8-0001
0002-Planner-side-changes-for-partition-pruning-v8.patch (text/plain) patch v8-0002
0003-Implement-get_partitions_from_clauses-v8.patch (text/plain) patch v8-0003
0004-Some-interface-changes-for-partition_bound_-cmp-bsea-v8.patch (text/plain) patch v8-0004
0005-Implement-get_partitions_for_keys-v8.patch (text/plain) patch v8-0005

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

Commits

Fix assorted partition pruning bugs
- d758d9702e2f 11.0 landed
Make gen_partprune_steps static
- d1e2cac5ff7e 11.0 landed
Remove useless 'default' clause
- c775fb9e18ac 11.0 landed
Reorganize partitioning code
- da6f3e45ddb6 11.0 landed
Use custom hash opclass for hash partition pruning
- fafec4cce814 11.0 landed
Blindly attempt to fix sepgsql tests broken due to 9fdb675fc5.
- 4f813c7203e0 11.0 landed
Attempt to fix endianess issues in new hash partition test.
- 40e42e1024c5 11.0 landed
Faster partition pruning
- 9fdb675fc5d2 11.0 landed
For partitionwise join, match on partcollation, not parttypcoll.
- 2af28e603319 11.0 landed
Revise API for partition bound search functions.
- f724022d0ae0 11.0 landed
Revise API for partition_rbound_cmp/partition_rbound_datum_cmp.
- b0229235564f 11.0 landed
Fix possible crash in partition-wise join.
- f069c91a5793 11.0 cited
Refactor code for partition bound searching
- 9aef173163ae 11.0 landed
New C function: bms_add_range
- 84940644de93 11.0 landed
Add extensive tests for partition pruning.
- 8d4e70a63bf8 11.0 landed
Add null test to partition constraint for default range partitions.
- 7b88d63a9122 11.0 cited
Remove BufFile's isTemp flag.
- 11e264517dff 11.0 cited
Make OWNER TO subcommand mention consistent
- bf54c0f05c0a 11.0 cited
Fix index matching for operators with mixed collatable/noncollatable inputs.
- cb37c291060d 9.2.0 cited