Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?
Date
Msg-id a2ae956b-d98f-4041-4e49-e37626684be4@enterprisedb.com
Whole thread Raw
In response to Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-performance
On 4/24/21 9:02 PM, Christophe Pettus wrote:
> 
> 
>> On Apr 24, 2021, at 11:27, Simon Connah <simon.n.connah@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
myproject. I planned to use btrfs on the server, but it got me thinking about PostgreSQL 13. Does anyone know if it
wouldhave 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



pgsql-performance by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?
Next
From: Rory Campbell-Lange
Date:
Subject: Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?