Avoid UUIDv4 Primary Keys

Re:Avoid UUIDv4 Primary Keys by dpark on Monday December 15, 2025 @01:44PM (#46278565)

> the prefix is an index to its disk block location

What? This is definitely not the case and can’t be because B-tree nodes change while UUIDs do not.

[ Parent | on HN ]

Re:Avoid UUIDv4 Primary Keys by mixmastamyk on Monday December 15, 2025 @01:45PM (#46278577)

I didn’t mean that literally, but no longer editable. Was supposed to have “like” etc in there.

[ Parent | on HN ]

Re:Avoid UUIDv4 Primary Keys by dpark on Monday December 15, 2025 @02:00PM (#46278766)

But UUIDv7 doesn’t change that at all. It doesn’t matter what flavor of UUID you choose. The ID is always “like” an index to a block in that you traverse the tree to find the node. What UUIDv7 does is improve some performance characteristics when creating new entries and potentially for caching.

[ Parent | on HN ]