3 ms·
Seems like this point is not understood very well by many. Ordered keys can create hot spots on insert and read, this can be good or bad depending on backend.
by SigmundA 6y ago
Seems like this point is not understood very well by many.
Ordered keys can create hot spots on insert and read, this can be good or bad depending on backend.
- kevincox 6y agoThe classic goldilocks problem. You want your pages to be hot, but not too hot.
- mywittyname 6y agoA hot-spot in one database index is collocated data in another. Sometimes you want uniform distribution of keys, sometimes you want clusters of keys because different databases are optimized based on assumptions about the underlying distribution of keys.