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

From Clemens Eisserer
Subject Re: PostgreSQL with ZFS on Linux
Date
Msg-id CAFvQSYSbuD-QeWh5Js+kaHKY3e3hVLvZL56yfLObja9fPjeHRQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL with ZFS on Linux  (Preston Hagar <prestonh@gmail.com>)
Responses Re: PostgreSQL with ZFS on Linux  (Sébastien Lorion <sl@thestrangefactory.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: Any freeware graphic display of DDL software available?
Next
From: Paul Jungwirth
Date:
Subject: Re: Any freeware graphic display of DDL software available?