AW: Best Filesystem for PostgreSQL

From: Stephan Schmidt <schmidt(at)dltmail(dot)de>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: AW: Best Filesystem for PostgreSQL
Date: 2019-04-18 02:19:28
Message-ID: BN7PR08MB4307BF17604BB8A5078908EAE8260@BN7PR08MB4307.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

my Question was meant for a Debian 9 environment with heavy read/wright load and very high requirements towards Performance and data Consistency

Stephan

________________________________
Von: Bruce Momjian <bruce(at)momjian(dot)us>
Gesendet: Wednesday, April 17, 2019 11:07:21 PM
An: Stephan Schmidt
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Betreff: Re: Best Filesystem for PostgreSQL

On Wed, Apr 17, 2019 at 08:59:13PM +0000, Stephan Schmidt wrote:
> What would be the best filesystem to run PostgreSQL on, in Terms of Performance
> and data Integrity?

Uh, which operating system? If it is Linux, many people like ext4 or
xfs. Some like zfs. ext3/ext2 are not recommended due to fsync
performance.

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

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gunther 2019-04-18 03:52:44 Re: Out of Memory errors are frustrating as heck!
Previous Message Gunther Schadow 2019-04-17 22:38:47 Re: Best Filesystem for PostgreSQL