Re: [HACKERS] 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: David Rowley <david.rowley@2ndquadrant.com>

Cc: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, Jesper Pedersen <jesper.pedersen@redhat.com>, Amit Langote <amitlangote09@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Beena Emerson <memissemerson@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2018-02-21T01:53:19Z

Lists: pgsql-hackers

Attachments

v31-0001-Modify-bound-comparision-functions-to-accept-mem.patch (text/plain) patch v31-0001
v31-0002-Refactor-partition-bound-search-functions.patch (text/plain) patch v31-0002
v31-0003-Add-parttypid-partcollation-partsupfunc-to-Parti.patch (text/plain) patch v31-0003
v31-0004-Faster-partition-pruning.patch (text/plain) patch v31-0004
v31-0005-Add-only-unpruned-partitioned-child-rels-to-part.patch (text/plain) patch v31-0005

On 2018/02/21 10:19, David Rowley wrote:
> v30-0004-Faster-partition-pruning.patch contains:
> 
> +create table coll_pruning_multi (a text) partition by range
> (substr(a, 1) collate "en_GB", substr(a, 1) collate "en_US");
> 
> This'll likely work okay on Linux. Other collate tests seem to use
> COLLATE "POSIX or "C" so that work cross-platform.

Thanks.  I completely forgot about that.  I've rewritten those tests to
use "POSIX" and "C" in the attached.

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