Get the latest tech news

Avoid UUID Version 4 Primary Keys in Postgres


Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually have bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Primary Keys

Primary Keys

Photo of UUIDv4 Primary Keys

UUIDv4 Primary Keys

Related news:

News photo

ULIDs and Primary Keys (2022)