Re: Best filesystem for a high load db - Mailing list pgsql-general

From Andy Colson
Subject Re: Best filesystem for a high load db
Date
Msg-id 5474F263.7010803@squeakycode.net
Whole thread Raw
In response to Best filesystem for a high load db  (Maila Fatticcioni <mfatticcioni@mbigroup.it>)
List pgsql-general
On 11/25/2014 9:43 AM, Maila Fatticcioni wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
> I need to install a Postgresql 9.4 cluster with two servers at first
> instance. The database will be used in an enviroment with high load, a
> lot number of clients will do queries that require fast replies.
> I have to install Ubuntu 14.04 as OS and I would like to know which
> filesystem you would suggest me to use. I have read that ZFS with ZIL
> is now mature for a production server: do you think it is that true or
> that it would be better to stay safer with a common EXT4?
>
> Thanks in advance.
>
> Maila Fatticcioni
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iEYEARECAAYFAlR0o68ACgkQi2q3wPb3FcM0/ACgwWEPZ+8dhvJPcjvoZq0GSfDJ
> 1p8AnjNFd2Mb9Nms4jTfRywn0MBmtVAW
> =wvKu
> -----END PGP SIGNATURE-----
>
>

A long while back I benched Ext4 vs xfs, and xfs won.

I've been using xfs for a long while now and love it.

You don't need to guess with mount options anymore.  The defaults are best.

-Andy



pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Lock Management: Waiting on locks
Next
From: Tom Lane
Date:
Subject: Re: SQL functions and triggers?