Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

On Sat, Apr 24, 2021 at 01:45:48PM -0500, Justin Pryzby wrote:
> On Sat, Apr 24, 2021 at 06:27:08PM +0000, Simon Connah 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?
>
> Is there some reason the question is specific to postgres13 , or did you just
> say that because it's your development target for your project.
>
> I think it almost certainly depends more on your project than on postgres 13.
>
> It may well be that performance is better under btrfs, maybe due to compression
> or COW. But you'd have to test what you're doing to find out - and maybe write
> up the results.
>
> Also, it's very possible that btfs performs better for (say) report queries,
> but worse for data loading. Maybe you care more about reporting, but that's
> not true for everyone.

My question is whether btrfs is reliable enough or write-durable enough
for Postgres. I would need a pretty good reason to not use ext4 or xfs.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.