Nikolay Samokhvalov: UUIDv4 vs UUIDv7: what a random primary key costs in Postgres

T2Covered by 1 source · first reported by Planet PostgreSQL at 05 Nov, 12:00 UTC

Same table, same insert stream, three primary keys on Postgres 18. At 100M rows, UUIDv4 inserted at 0.62 to 0.69 of the rate of an ordered key on the same server, and wrote 1.5 to 1.9 times the WAL per row. Where the cost starts, and what it is made of.

cloud

Sources

• T2Nikolay Samokhvalov: UUIDv4 vs UUIDv7: what a random primary key costs in PostgresPlanet PostgreSQL05 Nov, 12:00