News for hackers. Stuff that matters.

A comment on Unexpected downsides of UUID keys in PostgreSQL. Parent comment

Re:Unexpected downsides of UUID keys in PostgreSQL by jongjong on Thursday June 22, 2023 @10:10AM (#36432443)
You can but you add an additional database lookup step which will cost you more in performance (and latency) than just using UUIDs as the ID directly with a single table.
[ Parent | on HN ]
Re:Unexpected downsides of UUID keys in PostgreSQL by ramchip on Thursday June 22, 2023 @05:53PM (#36439592)
It's only at creation time. When you lookup the record after that you can use the ID directly, and then you don't hit the locality problems from the article.
[ Parent | on HN ]