On Wed, Jun 10, 2015 at 8:48 PM, Rosiński Krzysztof 2 - Detal <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
