Re: [idea] table partition + hash join - Mailing list 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)

)