From owner-freebsd-questions@FreeBSD.ORG  Thu Jun  3 14:42:59 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 915A216A4CE
	for <freebsd-questions@freebsd.org>;
	Thu,  3 Jun 2004 14:42:59 -0700 (PDT)
Received: from ns1.kenjim.com (brigitte.rhuidean.net [66.93.142.205])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5B4D343D46
	for <freebsd-questions@freebsd.org>;
	Thu,  3 Jun 2004 14:42:59 -0700 (PDT)
	(envelope-from kenji@ns1.kenjim.com)
Received: from ns1.kenjim.com (localhost.kenjim.com [127.0.0.1])
	by ns1.kenjim.com (8.12.6/8.12.6) with ESMTP id i53Lgrf3093505;
	Thu, 3 Jun 2004 14:42:53 -0700 (PDT)
	(envelope-from kenji@ns1.kenjim.com)
Received: (from kenji@localhost)
	by ns1.kenjim.com (8.12.6/8.12.6/Submit) id i53Lgr7d093504;
	Thu, 3 Jun 2004 14:42:53 -0700 (PDT)
Date: Thu, 3 Jun 2004 14:42:53 -0700
From: Kenji M <kenji@kenjim.com>
To: freebsd-questions@freebsd.org
Message-ID: <20040603214253.GA93387@kenjim.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.2.1i
cc: kenji@kenjim.com
Subject: Running FreeBSD/PostgreSQL on high-end dual Xeon box
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 03 Jun 2004 21:42:59 -0000

Hello everyone, first time list leech.

I am in the process of speccing out a high end PC to be used
as a database server for PostgreSQL.  We are currently running
MySQL on Linux, but want to migrate our code to PostgreSQL and 
we are primarily a FreeBSD shop.  

I am currently specing a 2U dual Xeon server and hope to use 
RAID 0+1 capability.  The question is for PostgreSQL admins...

1) Which RAID controller should we use?

2) Considering Q1, does it not even make sense to use FreeBSD+PostgreSQL
and bite the bullet and go with Linux (assuming it has better hw RAID 
support) and run PostgreSQL on that using a fancier journaling filesystem.

Any comments greatly appreciated.

-Kenji

-- 
+++++++++++++++++++++
kenji morishige
kenji@kenjim.com
http://www.kenjim.com
+++++++++++++++++++++