On Wed, Jun 10, 2015 at 8:48 PM, Rosiński Krzysztof 2 - Detal <krzysztof.rosins...@orange.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
