Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 46BDA5F9CED
	for <pgsql-performance@postgresql.org>;
	Tue, 24 Jul 2012 09:51:27 -0300 (ADT)
Received: from 10610.x.rootbsd.net ([204.109.60.69] helo=vps001.shopzeus.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gandalf@shopzeus.com>) id 1SteaB-00022p-8b
	for pgsql-performance@postgresql.org; Tue, 24 Jul 2012 12:51:26 +0000
Received: from [192.168.1.105] (localhost [127.0.0.1])
	by vps001.shopzeus.com (8.14.3/8.14.3) with ESMTP id q6OCp7B6041558
	for <pgsql-performance@postgresql.org>;
	Tue, 24 Jul 2012 08:51:08 -0400 (EDT)
	(envelope-from gandalf@shopzeus.com)
Message-ID: <500E9A3B.3070609@shopzeus.com>
Date: Tue, 24 Jul 2012 14:51:07 +0200
From: Laszlo Nagy <gandalf@shopzeus.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120714 Thunderbird/14.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: ZFS vs. UFS
Content-Type: multipart/alternative;
	boundary="------------000305000704060808090806"
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201207/293
X-Sequence-Number: 47474

This is a multi-part message in MIME format.
--------------000305000704060808090806
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


   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


--------------000305000704060808090806
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    &nbsp; Hello,<br>
    <br>
    Under FreeBSD 9, what filesystem should I use for PostgreSQL? (Dell
    PowerEdge 2900, 24G mem, 10x2T SATA2 disk, Intel RAID controller.)<br>
    <br>
    <ul>
      <li>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.</li>
      <li>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.</li>
    </ul>
    <p>I wonder if UFS has better performance or not. Or can you suggest
      another fs? Just of the PGDATA directory.<br>
    </p>
    <p>Thanks,<br>
    </p>
    <p>&nbsp;&nbsp; Laszlo<br>
      <br>
    </p>
  </body>
</html>

--------------000305000704060808090806--