UUIDv7 and the end of the random primary key
PostgreSQL 18 ships uuidv7() in core. It looks like a small convenience function. It is actually the end of a decade-long argument about UUID primary keys, and the numbers from a 200 million row table explain why. Migration path included, with the one gotcha around the timestamp you can extract.
11 min readRead more →