3 ms·
An operating system is usually optimized to perform well for a large variety of workloads. Databases have a very specific workload and there are some possible (
by danbruc 11y ago
An operating system is usually optimized to perform well for a large variety of workloads. Databases have a very specific workload and there are some possible (performance) optimizations if you, for example, bypass the operating system file caching and prefetching facilities and roll your own. Or if you control the scheduling of your operations. Take this with a grain of salt, it has been some time since I read about SQL Server internals, but this is what I remember.
- copperx 11y agoI understand, but that implies that the underlying OS is suboptimal for the task, doesn't it? I mean, Postgres doesn't do that in Linux, right?
- sciurus 11y agoThey don't, but that's not because they lack frustrations with Linux. https://lwn.net/Articles/591723/ https://lwn.net/Articles/591723/
- vram22 11y ago>bypass the operating system file caching Using raw partitions instead of file system files for database storage was common practice with Oracle and other DBs at one time. Not checked lately.