Re: [POC] hash partitioning

Amul Sul <sulamul@gmail.com>

From: amul sul <sulamul@gmail.com>

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

Cc: 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-09-27T07:05:37Z

Lists: pgsql-hackers

Attachments

0001-hash-partitioning_another_design-v21.patch (application/octet-stream) patch v21-0001

On Mon, Sep 18, 2017 at 8:55 PM, Jesper Pedersen <jesper.pedersen@redhat.com
> wrote:

> On 09/15/2017 02:30 AM, amul sul wrote:
>
>> Attached rebased patch, thanks.
>>
>>
> While reading through the patch I thought it would be better to keep
> MODULUS and REMAINDER in caps, if CREATE TABLE was in caps too in order to
> highlight that these are "keywords" for hash partition.
>
> Also updated some of the documentation.
>
>
Thanks a lot for the patch, included in the attached version.


> V20 patch passes make check-world, and my testing (typical 64 partitions,
> and various ATTACH/DETACH scenarios).
>

Nice, thanks again.

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