Postgres Pro
Downloads
Home   >   mailing lists

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

From Christophe Pettus
Subject Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?
Date
Msg-id 81E57D2B-58F5-4AA7-994E-899B6E93610A@thebuild.com
Whole thread Raw
In response to Does btrfs on Linux have a negative performance impact for PostgreSQL 13?  (Simon Connah <simon.n.connah@protonmail.com>)
Responses Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-performance
Tree view 

> 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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?
Next
From: Tomas Vondra
Date:
Subject: Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?