4 ms·
I was really hesitant to use uuids as primary keys because it’s basically worst case clustering performance. Ended up just using 32 bit Unix time followed by 12
by jon_richards 3y ago
I was really hesitant to use uuids as primary keys because it’s basically worst case clustering performance. Ended up just using 32 bit Unix time followed by 12 random bytes. Not sure why that isn’t an official version.
- PaulHoule 3y agoIf you insist on using a B-Tree index and random UUIDs that's certainly the case. Many of the formulas used to generate UUIDs in the past had terrible privacy implications: Office 95 would fill documents with UUIDs generated based on MAC addresses and timestamps so Office documents could be tracked to particular machines until Microsoft changed this with little fanfare.