Post B6bUCAiJENTfNjuoHg by ignaloidas@not.acu.lt
 (DIR) More posts by ignaloidas@not.acu.lt
 (DIR) Post #B6bUCAiJENTfNjuoHg by ignaloidas@not.acu.lt
       0 likes, 0 repeats
       
       Really really good paper on how to make databases do more to not kill SSDs through write amplification, it tests the stuff on a B-tree, but I think most optimizations mentioned should work for many different types of databases https://arxiv.org/pdf/2603.09927
       
 (DIR) Post #B6bUCAqSk401n1jJzc by ignaloidas@not.acu.lt
       0 likes, 0 repeats
       
       Also, really enjoy this pre-print exclusive talk about filesystems being useless for this stuff:Filesystems are also ill-suited for reducing total WAF. Situated between the DBMS and the SSD, they lack visibility into database-level access patterns and have no control over SSD-internal data placement. Consequently, they possess neither the workload knowledge required to lower DB WAF nor the low-level interface needed to mitigate SSD WAF.
       
 (DIR) Post #B6bUCB1o3t4cMD2Nfs by wolf480pl@mstdn.io
       0 likes, 0 repeats
       
       @ignaloidas"if you understand neither the SSD, nor the database, you will succumb to every write"
       
 (DIR) Post #B6bX0AQwkJd6tulGyG by ignaloidas@not.acu.lt
       0 likes, 0 repeats
       
       @wolf480pl@mstdn.io yupHonestly this made consider adding a database interface into my "dream OS" design. While it's not practical in desktops to have each application with it's own DB access the SSD directly, aggregating all that at OS/kernel level would be beneficial, and could viably benefit from FDP if that ever reaches consumer SSDs.
       
 (DIR) Post #B6bX0AohK0d25ZsEzY by wolf480pl@mstdn.io
       0 likes, 0 repeats
       
       @ignaloidasbtw it feels like I've seen this paper beforelike you've linked it in the past
       
 (DIR) Post #B6cbVOgaOsxF3UBS4m by michal@toot.kottman.xyz
       0 likes, 0 repeats
       
       @ignaloidas @wolf480pl And call it "Registry"?https://en.wikipedia.org/wiki/Windows_Registry
       
 (DIR) Post #B6cbVOtLdRA9h49dy4 by ignaloidas@not.acu.lt
       0 likes, 0 repeats
       
       @michal@toot.kottman.xyz @wolf480pl@mstdn.io so the problem is that windows only had configuration uses in mind, and nothing else really. I'd want something that's flexible enough to e.g. work for storing mailboxes in thunderbird. Kinda like a OS-wide SQLite, but not exactly SQLite because I don't really like that design.
       
 (DIR) Post #B6cbVP19AROw5Fns7k by wolf480pl@mstdn.io
       0 likes, 0 repeats
       
       @ignaloidasI wonder if z/OS has anything like that@michal