After reviewing some of the new features for Postgresql 11, I've noticed that they have added some very powerful features for table partitioning that will really help simplify application code. Looking forward to trying it out!
Conversation
Replying to
"To help with managing partitions, PostgreSQL 11 introduces a catch-all default partition for data that does not match a partition key, and the ability to create primary keys, foreign keys, indexes, and triggers on partitioned tables that are passed down to all partitions." WOW!