Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


>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.


db2 used to support/recommend raw block devices (this was ~8 years ago). I believe nowadays they are recommending using regular filesystems again.


Good to know.


I 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?


They don't, but that's not because they lack frustrations with Linux.

https://lwn.net/Articles/591723/




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: