On 08/24/2017 10:52 AM, Adam Brusselback wrote:
> My understanding is that global indexes allow foreign keys to work
> naturally with partitioned tables, or tables in an inheritance
> hierarchy. That is pretty big IMO, as it allows you to partition a
> table without making a trade-off in your database integrity.
It is, in fact the reason that even with 10 we don't really have
partitioning as much as syntactical sugar for partitioning. (Not trying
to take away from that, having the syntactical sugar is a huge first step).
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
***** Unless otherwise stated, opinions are my own. *****