Hey do you have an opinion on the github.com/tanglebones/pg which tries to fix the indexing of UUIDs... ?
Conversation
Replying to
UUIDs are just another data type to the B-Tree code, of course. Anything that makes UUID values have temporal locality must be good. I never really understood the appeal of UUIDs, so I can't comment much beyond that.
Replying to
Thanks for commenting! It was my impression too, but was wondering if maybe they implemented 8 bytes prefix search or something that would then make a big difference... or would it?
2
It depends on which problem you are trying to solve, but it should make a difference. I've had on the (way) back burner the idea of implementing a ULID type for this reason (github.com/ulid/spec) but if UUIDv6 becomes a thing, that should solve most postgres users needs.
2