Tapoueh compares primary key strategies for multi-region PostgreSQL logical replication
The author evaluates five different primary key strategies for multi-region PostgreSQL tables using logical replication, examining their performance costs in table size, WAL generation, index behavior, and resilience against region failovers and clock skews. The testing shows that uuidv7() and a custom time-based bigint pattern avoid the dangerous stale-state pitfalls of per-region sequences while maintaining efficient B-tree index density under high write concurrency. Open article →