3 ms·
> a concensus now that mmap should be avoided specially for databases Maybe, but table 1 in Andy Pavlo's paper shows 7 of 10 databases surveyed do still use mm
by eatonphil 4y ago
> a concensus now that mmap should be avoided specially for databases
Maybe, but table 1 in Andy Pavlo's paper shows 7 of 10 databases surveyed do still use mmap.
Furthermore, that paper clearly demonstrating the issues with mmap came out in 2022 and most databases have been around longer than that.
That mmap isn't the future is maybe more certain than that mmap isn't common practice today (because it does sorta seem to be).
- loeg 4y agoMy impression is that databases have known of the shortcomings of mmap since, like, the 90s. A critical flaw is the lack of error handling -- in addition to the unpredictable performance characteristics and naive caching. I'm looking forward to reading the paper.