杰里米·施耐德：UUID基准测试之战
原文英文，约1700词，阅读约需6分钟。发表于：。This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have decided to...
本文比较了四种不同的主键存储方法：文本字段存储UUID、PostgreSQL的uuid数据类型、uuidv7代码和bigint。测试结果显示，uuidv7性能优于bigint，而uuidv4与bigint性能相当。文章还讨论了缓存压力对性能的影响以及UUID和bigint的大小差异。
