'PostgreSQL 13 Partition Global Indexing Strategies
Based on my research so far, I understand that it is not possible to create an out-of-the-box global index across partitions in PostgreSQL 13.
Are there any alternative strategies that can facilitate the requirement of a global index across partitions?
Greatly appreciate any resource references on the topic. Thanks!
Solution 1:[1]
No, there is no simple, cheap and reliable way to guarantee uniqueness of a column that is not the partitioning key. The only option is a trigger, but that requires that you use SERIALIZABLE transaction isolation.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Laurenz Albe |