Re:Unexpected downsides of UUID keys in PostgreSQL
by magicalhippo on Thursday June 22, 2023 @09:50AM
(#36432153)
Reminds me of a talk about ZFS performance, where they presented some benchmark results showing that as the number of concurrent clints doing pure sequential IO increases, the more the load appears as random IO to the filesystem.
So with high enough concurrent load it's effectively all random IO and that's the primary thing worth optimizing for.
So with high enough concurrent load it's effectively all random IO and that's the primary thing worth optimizing for.