News for hackers. Stuff that matters.
Re:Are you sure you want to use MMAP in your database manage... by electricshampo1 on Friday January 14, 2022 @04:46PM (#29940887)
Generally for perf critical use cases you dedicate the machine to the database. This simplifies many things (avoiding having to reason about sharing, etc etc).
Re:Are you sure you want to use MMAP in your database manage... by munchler on Friday January 14, 2022 @04:55PM (#29940994)
This makes me wonder whether there would be value in an OS that is also a DBMS (or vice versa). In other words, if the DBMS has total control over the hardware, perhaps performance can be maximized without too much additional complexity.
Re:Are you sure you want to use MMAP in your database manage... by matt_d on Friday January 14, 2022 @09:11PM (#29942925)
One example is DBOS: A Database-oriented Operating System, https://dbos-project.github.io/ / https://github.com/DBOS-project (more details under "Publications").
Re:Are you sure you want to use MMAP in your database manage... by sedachv on Friday January 14, 2022 @05:15PM (#29941232)
This is a bad idea from the 1960s: IBM TPF, MUMPS, Pick. As soon as the hardware changes it becomes slower and more complicated.
Re:Are you sure you want to use MMAP in your database manage... by yellowapple on Saturday January 15, 2022 @05:01AM (#29945219)
That was back when hardware was changing to a significant degree, though. Nowadays, there ain't really much that's new about hardware today v. hardware from 10 or 20 years ago - hence operating systems / filesystems being able to remain mostly stable instead of suffering from the exact same problem.