Developer
Aug 6, 2026
UUID v4 Breaks Database Performance at Scale — What UUID v7 Changed and Why It's Still Not the Default
UUID v4's random ordering causes B-tree page splits throughout the entire index at high insert rates — reducing throughput by 30-50% compared to sequential keys. UUID v7 (RFC 9562, May 2024) puts a 48-bit millisecond timestamp in the most significant bits, making inserts approximately sequential and eliminating most page splits. Here's why UUID v1 exposed machine MAC addresses, how UUID v5 generates deterministic UUIDs from a namespace and name, and why UUID v4 is still more widely used despite UUID v7 being superior for databases.