indexes on partitioned tables - on the base table, or the partitioned tables? - Mailing list pgsql-general

Hi all;

where's the best place for the indexes/constraints on a partitioned table.

I assume it's best to place the FK constraints/triggers on the base/master
table and the indexes on the individual partition tables.

Thoughts?

Thanks in advance.