Re: PostgreSQL with ZFS on Linux - Mailing list pgsql-general

From Sébastien Lorion
Subject Re: PostgreSQL with ZFS on Linux
Date
Msg-id CAGa5y0MGhO=adjdwhe5ETzHZ0gEPx_d9Y6aBXgHMBxQTe+9OZQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL with ZFS on Linux  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
On Thu, Jan 16, 2014 at 6:09 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
http://www.unix-experience.fr/2013/2451/

FreeBSD is also a very mature platform for ZFS/postgresql.

It is more mature than Linux for sure, but still not up to par with Solaris for some features. See this comment for example: http://www.dslreports.com/forum/r27269032-. I do like FreeBSD very much, but it seems to me that if I want to use ZFS to its fullest, I should go with OpenIndiana.

In the benchmark you link, ZFS+opti (orange line, physical machine benchmark) performs well because it has sync=disabled, which is risky to say the least ...

 


On 16/01/2014 11:57, Sébastien Lorion wrote:
On Thu, Jan 16, 2014 at 4:22 AM, Sébastien Lorion <sl@thestrangefactory.com> wrote:
Hello,

Since ZFS on Linux (http://zfsonlinux.org/) has been declared production ready last March (v0.6.1), I am curious if anyone is using it with PostgreSQL on production servers (either main or backup) and if so, what is their experience so far ?

Thank you,

Sébastien

FYI, a recent (Sept. 2013) presentation I found about using ZoL in production (albeit, not with PostgreSQL) and the current status of the project:



-- 
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt

pgsql-general by date:

Previous
From: Dann Corbit
Date:
Subject: Re: Any freeware graphic display of DDL software available?
Next
From: Sébastien Lorion
Date:
Subject: Re: PostgreSQL with ZFS on Linux