News for hackers. Stuff that matters.
Re:Unexpected downsides of UUID keys in PostgreSQL by pkilgore on Friday June 23, 2023 @05:38PM (#36452489)
It just orders ids based on a monotonic clock that wraps after a certain time -- it's enough to get a lot of of the performance benefit of ordered keys without directly exposing the unix wall clock time they were created (absent a dedicated attacker with the ability to create ids without you picking up on it for a timing attack, I suppose).

Whether that tradeoff makes sense probably depends.

There are no comments on this comment yet.