The author should include benchmarks otherwise, saying that UUIDs “increase latency” is meaningless. For instance, how much longer does it take to insert a UUID vs. an integer? How much longer does scanning an index take?
The author doesn't reference any tests that they themselves ran, but they did link a cybertec article [0] with some benchmarks.
[0] https://www.cybertec-postgresql.com/en/unexpected-downsides-...
The author doesn't reference any tests that they themselves ran, but they did link a cybertec article [0] with some benchmarks.
[0] https://www.cybertec-postgresql.com/en/unexpected-downsides-...