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: jesper.pedersen@redhat.com, David Rowley <david.rowley@2ndquadrant.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Robert Haas <robertmhaas@gmail.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, 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-04-05T08:31:41Z

Lists: pgsql-hackers

Attachments

v50-0001-Add-partsupfunc-to-PartitionSchemeData.patch (text/plain) patch v50-0001
v50-0002-Expose-PartitionBoundInfoData-to-rest-of-the-bac.patch (text/plain) patch v50-0002
v50-0003-Add-more-tests-for-partition-pruning.patch (text/plain) patch v50-0003
v50-0004-Faster-partition-pruning.patch (text/plain) patch v50-0004
v50-0005-Add-only-unpruned-partitioned-child-rels-to-part.patch (text/plain) patch v50-0005

On 2018/04/05 17:28, Amit Langote wrote:
> Attached v50.

Really attached this time.

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