UUID Benchmark

5 runs per configuration · Median reported · Fresh container per UUID type · 100K–10M records

KEY FINDINGS

◎INSERT PENALTY

−13.6% to −30%

UUIDv4 slower than sequential

100K1M10M

◎STRUCTURAL DAMAGE

49.8%

UUIDv4 leaf fragmentation, PostgreSQL

100K1M10M

◎SCALE EFFECT

−73%

UUIDv4 throughput at 10M, MySQL

100K1M10M

◎BEST BALANCE

UUIDv7

best balance across B-tree systems; near-equivalent in Cassandra

PGMYMOCA

POSTGRESQL

B-tree / heap-organized

pgbench

MYSQL

Clustered B-tree (InnoDB)

Go workload binary

MONGODB

WiredTiger B-tree index

Go workload binary

CASSANDRA

LSM-tree / SSTables

Go workload binary