Skip to content
Global sound
Postgres FM

Postgres FM

UUIDv4 vs UUIDv7

· 48 min · Episode 194

Show notes

Nik is joined by Kirk Wolak to discuss what a random UUIDv4 primary key really costs compared with a time-ordered UUIDv7 or an int8 key on Postgres 18 — index size, WAL and full-page writes, insert rate once the index outgrows memory — and what DBLab Forge found when it ran the experiment.

Website: share.transistor.fm

Live, last hour: 2,192 songs on 7,706 stations in 142 countries

Discover the world through radio

More ways to discover (9)

Heard something good? Save it, or open it straight away in Spotify.

Radio WeekendContinue listening