Re: [idea] table partition + hash join

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Rosiński Krzysztof 2 - Detal <Krzysztof(dot)Rosinski2(at)orange(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [idea] table partition + hash join
Date: 2015-06-11 01:15:13
Message-ID: CA+HiwqHGSuW-uk6E615KaxcDc8VA2L2X269dbEvx2XB-8SYReg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 10, 2015 at 8:48 PM, Rosiński Krzysztof 2 - Detal
<Krzysztof(dot)Rosinski2(at)orange(dot)com> wrote:
> How to use this optimization ?
>
>
>
> select *
>
> from table join partitioned_table on (
>
> table.part_id = partitioned_table.id
>
> and hash_func_mod(table.part_id) = hash_func_mod(partitioned_table.id)
>
> )
>

If I read the proposed idea correctly, you wouldn't need to add that
second condition.

Thanks,
Amit

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-06-11 01:21:59 Re: minor issues in pg_rewind
Previous Message Peter Eisentraut 2015-06-11 00:10:10 Re: error message diff with Perl 5.22.0