On 4/24/21 9:02 PM, Christophe Pettus wrote:
On Apr 24, 2021, at 11:27, Simon Connah <simon.n.con...@protonmail.com> wrote: I'm curious, really. I use btrfs as my filesystem on my home systems and am setting up a server as I near releasing my project. I planned to use btrfs on the server, but it got me thinking about PostgreSQL 13. Does anyone know if it would have a major performance impact?This is a few years old, but Tomas Vondra did a presentation comparing major Linux file systems for PostgreSQL: https://www.slideshare.net/fuzzycz/postgresql-on-ext4-xfs-btrfs-and-zfs
That talk was ages ago, though. The general conclusions may be still valid, but maybe btrfs improved a lot - I haven't done any testing since then. Not sure about durability, but there are companies using btrfs so perhaps it's fine - not sure.
Arguably, a lot of this also depends on the exact workload - the issues I saw with btrfs were with OLTP stress test, it could have performed much better with other workloads.
regards Tomas
