Re: [HACKERS] [idea] table partition + hash join

[Rosiński Krzysztof 2 - Detal]

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