Re: PostgreSQL with ZFS on Linux

On Thu, Jan 16, 2014 at 6:09 AM, Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)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(at)thestrangefactory(dot)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:
>
> http://lanyrd.com/2013/linuxcon-north-america/scqmfb/
>
>
>
> --
> Achilleas Mantzios
> Head of IT DEV
> IT DEPT
> Dynacom Tankers Mgmt
>
>