From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Best filesystem for a high load db |
Date: | 2014-11-25 21:19:31 |
Message-ID: | 5474F263.7010803@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-11-25 21:24:25 | Re: SQL functions and triggers? |
Previous Message | Dev Kumkar | 2014-11-25 21:07:51 | Lock Management: Waiting on locks |