Re: Best Filesystem for PostgreSQL

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Stephan Schmidt <schmidt(at)dltmail(dot)de>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Best Filesystem for PostgreSQL
Date: 2019-04-18 15:33:57
Message-ID: 20190418153357.km3jwyhdenflkh7o@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Apr 18, 2019 at 02:19:28AM +0000, Stephan Schmidt wrote:
>my Question was meant for a Debian 9 environment with heavy read/wright
>load and very high requirements towards Performance and data Consistency
>

Well, that's like asking "which car is the best" unfortunately. There's no
good answer, as it very much depends on your expectations, hardware etc.
Everyone wants good performance, reliability and consistency.

Simply said, if you're on current Linux and you don't have any additional
requirements (like snapshotting), then ext4/xfs are likely your best bet.
There are differences between these two filesystems, but it depends on the
workload, hardware etc. Overall the behavior is pretty close, though. So
either you just go with either of those, or you do some testing with your
application on the actual hardware.

If you need something more advanced (like better snapshotting, etc.) then
maybe ZFS is the right choice for you. It also allos various advanced
configurations with ZIL, L2ARC, ...

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Blayzor 2019-04-18 18:11:58 Re: Best Filesystem for PostgreSQL
Previous Message Tomas Vondra 2019-04-18 15:21:28 Re: Out of Memory errors are frustrating as heck!