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

2026-11-05来源 Planet PostgreSQLEnglish
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.

原文：https://www.a8q9.cn/en/article/nikolay-samokhvalov-uuidv4-vs-uuidv7-what-a-random-primary-key-costs-in-postgres-ff22d2.html

相关文章