5 ms·

What exactly are the reasons to not use btrfs?

• chasil 2y ago
  While btrfs is stable, it will not run heavy database loads well with the default settings. https://archive.ph/dqFgh https://archive.ph/dqFgh Oracle explicitly does not support brtfs for their database.
  • bradfa 2y ago
    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.
    • chasil 2y ago
      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 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!
    • taffer 2y ago
      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-performance-comparison https://www.enterprisedb.com/blog/postgres-vs-file-systems-p... [2] https://www.phoronix.com/review/bcachefs-benchmarks-linux67 https://www.phoronix.com/review/bcachefs-benchmarks-linux67