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

While btrfs is stable, it will not run heavy database loads well with the default settings.

https://archive.ph/dqFgh

Oracle explicitly does not support brtfs for their database.



That article is from 9 years ago. Is there any more recent review which comes to similar conclusions?

But also, if you’re running sqlite, your main goal is probably not to be a database server but to do some other primary objective that happens to benefit from using a database for some things.


Here are some articles from 2022 and 2023. Btrfs database performance is still a disaster.

[1] https://www.enterprisedb.com/blog/postgres-vs-file-systems-p...

[2] https://www.phoronix.com/review/bcachefs-benchmarks-linux67


I am not trying to run oltp on btrfs, so I don't personally need more recent knowledge.

A quick search suggests:

https://news.ycombinator.com/item?id=10257466

I am sure that you will find far more detail in your own research, should this motivate you. Good luck!




Consider applying for YC's Summer 2026 batch! Applications are open till May 4

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

Search: