Search Postgresql Archives

Re: Best filesystem for a high load db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux