From owner-freebsd-amd64@FreeBSD.ORG  Mon Mar 19 15:38:58 2007
Return-Path: <owner-freebsd-amd64@FreeBSD.ORG>
X-Original-To: freebsd-amd64@freebsd.org
Delivered-To: freebsd-amd64@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 57C1516A400;
	Mon, 19 Mar 2007 15:38:58 +0000 (UTC) (envelope-from vivek@khera.org)
Received: from yertle.kcilink.com (yertle.kcilink.com [74.92.149.58])
	by mx1.freebsd.org (Postfix) with ESMTP id 2A8B713C4B8;
	Mon, 19 Mar 2007 15:38:57 +0000 (UTC) (envelope-from vivek@khera.org)
Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103])
	by yertle.kcilink.com (Postfix) with ESMTP id 4EC2CB81E;
	Mon, 19 Mar 2007 11:38:57 -0400 (EDT)
In-Reply-To: <7489C7AA-BD33-4144-ABD4-73338CD5C7C7@Chaos1.DE>
References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
	<b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com>
	<111EFCD1-0B88-4646-BCF5-B13D1F3BBCB0@khera.org>
	<7489C7AA-BD33-4144-ABD4-73338CD5C7C7@Chaos1.DE>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <CBF10BDF-C0D4-4D40-9F35-B9F8CF89D96B@khera.org>
Content-Transfer-Encoding: 7bit
From: Vivek Khera <vivek@khera.org>
Date: Mon, 19 Mar 2007 11:38:56 -0400
To: freebsd-database@freebsd.org
X-Mailer: Apple Mail (2.752.2)
Cc: FreeBSD AMD list <freebsd-amd64@freebsd.org>
Subject: Re: New Opteron box, dedicated to PostgreSQL
X-BeenThere: freebsd-amd64@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting FreeBSD to the AMD64 platform <freebsd-amd64.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-amd64>
List-Post: <mailto:freebsd-amd64@freebsd.org>
List-Help: <mailto:freebsd-amd64-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 19 Mar 2007 15:38:58 -0000


On Mar 18, 2007, at 7:51 AM, Axel Rau wrote:

> This box will have an Areca ARC-1261ML (RAID 1 for OS and WAL, RAID  
> 0 with 7xRAID1 for pg_data).
> Any hints beside the usual partition alignment and stripe size of  
> 128kB ?
> Do you use ufs2 with softupdates?

You don't value your data?  Why not RAID10?

I use UFS2 with softupdates.  I generally use the default RAID stripe  
sizes. Postgres works in 8k pages, so if you have a lot of locality  
in your db reference, larger stripes might help.  I don't know.