Message-ID: <500E9D31.6050107@oles.biz>
Date: Tue, 24 Jul 2012 16:03:45 +0300
From: Georgi Naplatanov <gosho@oles.biz>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.16) Gecko/20120613 Icedove/3.0.11
MIME-Version: 1.0
To: Laszlo Nagy <gandalf@shopzeus.com>
CC: pgsql-performance@postgresql.org
Subject: Re: ZFS vs. UFS
References: <500E9A3B.3070609@shopzeus.com>
In-Reply-To: <500E9A3B.3070609@shopzeus.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi.

As far as I know UFS is faster than ZFS on FreeBSD 9.0.

Some users reported stability problem with ZFS on AMD64 and maybe UFS is 
better choice.

Best regards
Georgi

On 07/24/2012 03:51 PM, Laszlo Nagy wrote:
>
> Hello,
>
> Under FreeBSD 9, what filesystem should I use for PostgreSQL? (Dell
> PowerEdge 2900, 24G mem, 10x2T SATA2 disk, Intel RAID controller.)
>
>     * ZFS is journaled, and it is more independent of the hardware. So
>       if the computer goes wrong, I can move the zfs array to a
>       different server.
>     * UFS is not journaled. Also I have to rely on the RAID card to
>       build the RAID array. If there is a hw problem with it, then I
>       won't be able to recover the data easily.
>
> I wonder if UFS has better performance or not. Or can you suggest
> another fs? Just of the PGDATA directory.
>
> Thanks,
>
> Laszlo
>