News for hackers. Stuff that matters.
Re:Showdown: MySQL 8 vs. PostgreSQL 10 by sakuronto on Wednesday May 23, 2018 @01:38PM (#17136153)
What if you just want a stable row ordering, and don't care what that ordering is?
Re:Showdown: MySQL 8 vs. PostgreSQL 10 by DrJosiah on Wednesday May 23, 2018 @02:02PM (#17136424)
For random (and not timespace prefixed) uuids, you can end up hitting more blocks because if locality of reference, if you are using b+trees. If you are using an lsm index, you get blocks of data written at the same time in the index anyway, so your "slow" disk isn't so bad, because that is in your cache already. For b+trees and random uuids, data in blocks are basically scattered everywhere. So your index lookup of 1 billion items could hit 1 billion leaf blocks, instead of 1 billion / entries per leaf.