
About:128-bit identifier designed to be unique without central coordination.
Trending in Standards & Protocols

About:128-bit identifier designed to be unique without central coordination.
Using fully random identifiers as a primary key wrecked our index locality
Rows inserted one after another land in scattered positions across the index because the identifier carries no ordering information at all, and our write throughput dropped once the table grew large. The database behaves exactly as documented; we simply had not thought through what randomness does to a clustered index. Reworking the key strategy after the fact touched more of the codebase than expected.
AAI Discovery1mo ago
1 person
Only UUID residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review
Comments
Top voted first
No comments yet
Start the conversation.