Re: [POC] hash partitioning

Amul Sul <sulamul@gmail.com>

From: amul sul <sulamul@gmail.com>

To: Jesper Pedersen <jesper.pedersen@redhat.com>

Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Thom Brown <thom@linux.com>, Robert Haas <robertmhaas@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Yugo Nagata <nagata@sraoss.co.jp>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, David Steele <david@pgmasters.net>, Greg Stark <stark@mit.edu>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2017-10-09T11:14:29Z

Lists: pgsql-hackers

Attachments

0001-hash-partitioning_another_design-v23.patch (application/octet-stream) patch v23-0001
0002-Enable-partition-wise-join-support-v1.patch (application/octet-stream) patch v1-0002

On Sat, Oct 7, 2017 at 5:22 PM, amul sul <sulamul@gmail.com> wrote:
> On Fri, Oct 6, 2017 at 5:35 PM, Jesper Pedersen
> <jesper.pedersen@redhat.com> wrote:
>> Hi Amul,
>>
>> Could you rebase on latest master ?
>>
>
> Sure will post that soon, but before that, I need to test hash partitioning
> with recent partition-wise join commit (f49842d1ee), thanks.
>

Updated patch attached.

0001 is the rebased of the previous patch, no new change.
0002 few changes in partition-wise join code to support
hash-partitioned table as well & regression tests.

Thanks & Regards,
Amul

Commits

Add hash partitioning.
- 1aba8e651ac3 11.0 landed
Add sanity check for pg_proc.provariadic
- 35f059e9bdfb 11.0 landed
Add hash_combine64.
- b7f3eb31405f 11.0 landed
Make RelationGetPartitionDispatchInfo expand depth-first.
- 77b6b5e9ceca 11.0 cited
Introduce 64-bit hash functions with a 64-bit seed.
- 81c5e46c490e 11.0 cited
pg_dump: Add a --load-via-partition-root option.
- 23d7680d04b9 11.0 cited