chiprook
← Software
SoftwareOctober 18, 2026, 11:46

Benchmark: UUIDv7 in PostgreSQL 18 matches bigint insert speed

Loading 10 million rows into PostgreSQL 18.6 keyed by UUIDv7 took 37.3 s, the same as bigint, while UUIDv4 took 84.2 s and wrote 2.2x more WAL. The UUIDv7 primary key index was 301 MB versus 385 MB for UUIDv4, though 41% larger than bigint's.

Benchmark: UUIDv7 in PostgreSQL 18 matches bigint insert speed
#PostgreSQL
Read next
AI

Creative Writing Benchmark: Frontier AI Matches Amateurs but Trails Professionals

AI

MiniMax M3.1 Flash Matches GPT-6 in Speed and Efficiency

Software

MongoDB 8.2 encrypted substring search costs 20x more per insert than equality

Science

Compact CRISPR alternative inserts large DNA segments using bacterial proteins