| 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
| 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 |