Philippe Gaultier • 9/12/2026

Optimization tales in production with CockroachDB: UUID generation (part 5)

Part 5 of a CockroachDB optimization series explores how UUID v4 primary keys in REGIONAL BY ROW tables trigger expensive cross-region uniqueness checks. The author explains the serializable isolation mechanics behind this slowness and reveals a simple trick that delivers a 50x speed-up, with production impact and conclusions.

0 comments

#sql optimization #uuid #Multi Region