Re:Unexpected downsides of UUID keys in PostgreSQL
by pkilgore on Thursday June 22, 2023 @09:56AM
(#36432241)
COMB UUIDs can help here.
[ Parent
| on HN ]
Re:Unexpected downsides of UUID keys in PostgreSQL
by fauigerzigerk on Thursday June 22, 2023 @12:37PM
(#36434786)
Why do COMB UUIDs not have this problem? Do they not contain a timestamp?
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.