Is a partition a relation? Is a partition a relation in its own right, or is a partitioned table a single relation? Specifically, do we need to increase max_fsm_relations when we split tables up into loads of partitions?
When you Partition a table, physical tables are created and when you query table with where predicates on partition only partition tables queried, you can also query a particular partition.