3 ms·
All modern databases do large block streaming appending writes, and small random reads, usually of just a handful of files. It ought to be easy to design a fil
by londons_explore 3y ago
All modern databases do large block streaming appending writes, and small random reads, usually of just a handful of files.
It ought to be easy to design a filesystem which can have pretty much zero overhead for those two operations. I'm kinda disappointed that every filesystem doesn't perform identically for the database workload.
I totally understand that different file systems would do different tradeoffs affecting directory listing, tiny file creation/deletion, traversing deep directory trees, etc. But random reads of a huge file ought to perform near identically to the underlying storage medium.
- rubiquity 3y agoWhat you’re describing is basically ext4. I do know there are some proprietary databases that use raw block devices. The downside being that you also need to make your own user space utilities for inspecting and managing it.