Re: [idea] table partition + hash join

From: Rosiński Krzysztof 2 - Detal <Krzysztof(dot)Rosinski2(at)orange(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [idea] table partition + hash join
Date: 2015-06-10 11:48:09
Message-ID: EC285B91B53E5343BDF78D3854C7BBCAB6795894@OPE10MB02.tp.gk.corp.tepenet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Prakash Itnal 2015-06-10 12:06:39 Auto-vacuum is not running in 9.1.12
Previous Message Kouhei Kaigai 2015-06-10 11:33:29 Re: [idea] table partition + hash join