On 09/15/2017 12:45 PM, Adam Brusselback wrote:
I cannot image a single postgres index covering more than one
physical table. Are you really asking for that?
While not available yet, that is a feature that has had discussion
before. Global indexes are what i've seen it called in those
discussions. One of the main use cases is to provide uniqueness
across multiple tables, which would also allow things like foreign
keys on partitioned tables.
I had a sneaking suspicion that partitioning would be the use-case, but
clearly there's at least the 'notion' of a single entity
