Re: PostgreSQL with ZFS on Linux

On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer <linuxhippy(at)gmail(dot)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(at)postgresql(dot)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):

http://www.anchor.com.au/blog/2013/04/the-btrfs-backup-experiment/
http://arstechnica.com/civis/viewtopic.php?f=16&t=1221177

Sébastien