4 ms·
I think this really only matters for clustered indexes.
by sroussey 3y ago
I think this really only matters for clustered indexes.
- masklinn 3y agoA clustered index means the entire table data is included. It’s the same issue, just to an even higher degree.
- Tostino 3y agoNo, you will have much larger index bloat as you add rows as page splits happen to accommodate the new rows.
- sgarland 3y agoNope. Performance and WAL bloat will both occur. https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/ https://www.cybertec-postgresql.com/en/unexpected-downsides-...
- sroussey 3y agoThis is a great article, thank you!
- sroussey 3y agoI wonder how this works out for MySQL. Any time I’ve used uuid there I’ve used my own version (more like v7 that is available now). This makes a big difference for the primary key (clustered index for both MySQL and postgresql). Does anyone have an analysis for MySQL secondary indexes like the above referenced one for PostgreSQL secondary indexes?
- sgarland 3y agoMySQL stores the PK with every secondary index, and uses it to retrieve the requested rows (unless the query is covered by the index). I’d think for most queries, this would result in a similar slowdown.