2 ms·
On the subject of completely free speedups to databases, someone sent a patch to MySQL many years ago that loads the text into hugepages, to reduce iTLB misses.
by jeffbee 2y ago
On the subject of completely free speedups to databases, someone sent a patch to MySQL many years ago that loads the text into hugepages, to reduce iTLB misses. It has large speedups and no negative consequences so of course it was ignored. The number of well-known techniques that FOSS projects refuse to adopt is large.
- paulryanrogers 2y agoMySQL has adopted a lot of performance work from FB, Google, and others. Though I suspect they want their implementation for license reasons.
- pgaddict 2y agoI guess it's this MySQL bug: https://bugs.mysql.com/bug.php?id=101369 https://bugs.mysql.com/bug.php?id=101369 which seems to have stalled after request ti sign an OCA. Anyway, I have no idea what would it take to do something like that in Postgres, I'm not familiar with this sfuff. But if someone submits a patch with some measurements, I'm sure we'll take a look.