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

From Chris Travers
Subject Re: PostgreSQL with ZFS on Linux
Date
Msg-id CAKt_Zfu_U035EgZggJ0nZdJjjH6Ck22tHVH35ugJWgxCuenVHA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL with ZFS on Linux  (Sébastien Lorion <sl@thestrangefactory.com>)
Responses Re: PostgreSQL with ZFS on Linux  (Sébastien Lorion <sl@thestrangefactory.com>)
List pgsql-general


On Thu, Jan 16, 2014 at 11:14 PM, Sébastien Lorion <sl@thestrangefactory.com> wrote:
On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer <linuxhippy@gmail.com> wrote:
Hi,

> If you really want ZFS, I would highly recommend looking into
> FreeBSD (Postgresql works great on it) or if you want to stick with Linux,
> look into mdadm with LVM or some other filesystem solution.

If you want to use ZFS because of its features, take a look at btrfs.
It provides a lot of the stuff supported by ZFS with usually better
performance on linux - and since the last few kernel revisions it is
finally in a state where I would dare to use it in production.

If you need highest performance, don't use a copy-on-write filesystem
like ZFS or btrfs, stick to ext4 or XFS ;)

Regards, Clemens


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


Do you have any personal experience with BTRFS for a couple of weeks in production or any official statement/case study ? On the FAQ, it says it is still experimental (https://btrfs.wiki.kernel.org/index.php/FAQ), though it may just be outdated. There is also these two links that would make me very cautious (as I am with ZFS on Linux, mind you):


We're looking at it for LedgerSMB hosting (with PostgreSQL, we are currently using XFS).  So far we are liking what we are seeing.  We wouldn't be using it for PostgreSQL backups, but the general sense is that the developers are very, very conservative about making guarantees of stability and so far we haven't seen any indication that "experimental" means anything other than "developers nervous about calling it stable."
 
This being said, we aren't very far into our evaluation yet and our view could change.

--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

pgsql-general by date:

Previous
From: Sébastien Lorion
Date:
Subject: Re: PostgreSQL with ZFS on Linux
Next
From: Laurence Rowe
Date:
Subject: json_array_elements_text?