Re:Unexpected downsides of UUID keys in PostgreSQL
by insanitybit on Thursday June 22, 2023 @12:26PM
(#36434612)
Hashes evenly distribute information regardless of the input. You will never have locality unless your dataset is so small that all of it can fit into a single cache line.
Your solution just doesn't really make any sense. The time ordered UUID suggested in the blog post makes way more sense.
Your solution just doesn't really make any sense. The time ordered UUID suggested in the blog post makes way more sense.