News for hackers. Stuff that matters.
Re:Bug Hunting in Btrfs by londons_explore on Wednesday March 20, 2024 @10:55AM (#39767513)
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.

Re:Bug Hunting in Btrfs by rubiquity on Wednesday March 20, 2024 @11:38AM (#39768113)
What 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.