1.0 Introduction In my previous post here, I introduced the global unique index feature that my colleague, David, and I work together and explained how global unique index guarantees cross-partition uniqueness during CREATE. In this blog, I will explain how we implement cross-partition uniqueness with ATTACH and a potential deficiency in this approach. 2.0 Global… Read more The post Global Unique Index ATTACH Support and Its Potential Deficiency first appeared on Highgo Software Inc.. The p...| Highgo Software Inc.
1.0 Introduction My colleague, David, recently published a post "Global Index, a different approach" that describes the work that we are doing to implement global unique index in an approach that does not change current PostgreSQL's partitioning framework, while allowing cross-partition uniqueness constraint. To implement this, we must first know how PostgreSQL currently ensures uniqueness| Highgo Software Inc. - Enterprise PostgreSQL Solutions