Re:Random identifiers are poorly compressible
by mjburgess on Sunday September 12, 2021 @08:45AM
(#28500642)
> " First, most of the existing UUID versions such as UUIDv4 have poor database index locality. Meaning new values created in succession are not close to each other in the index and thus require inserts to be performed at random locations. The negative performance effects of which on common structures used for this (B-tree and its variants) can be dramatic. As such newly inserted values SHOULD be time-ordered to address this."
-- https://datatracker.ietf.org/doc/html/draft-peabody-dispatch...