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@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
