AW: Best Filesystem for PostgreSQL

Stephan Schmidt <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <BN7PR08MB4307BF17604BB8A5078908EAE8260@BN7PR08MB4307.namprd08.prod.outlook.com>
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 <[email protected]>
Gesendet: Wednesday, April 17, 2019 11:07:21 PM
An: Stephan Schmidt
Cc: [email protected]
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  <[email protected]>        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 +
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.