2ndquadrant.com/en/blog/sequential-uuid-gen… UUIDs vs performance
2ndQuadrant | PostgreSQL
Sequential UUID Generators - 2ndQuadrant | PostgreSQLsequential-uuids extension introduces generators of sequential UUIDs, addressing some of the common issues - random I/O patterns and WAL write amplification
1 comment
@Benjie
Benjie3yr ago

Important to note that these tests were ran on spinning disks (7200rpm) - the metrics are likely to be quite different on SSDs.