From owner-freebsd-performance@FreeBSD.ORG  Wed Jan 30 09:31:43 2008
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 920A516A41B;
	Wed, 30 Jan 2008 09:31:43 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id 329C313C457;
	Wed, 30 Jan 2008 09:31:42 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <47A043FD.9090607@FreeBSD.org>
Date: Wed, 30 Jan 2008 10:31:41 +0100
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031)
MIME-Version: 1.0
To: Claus Guttesen <kometen@gmail.com>
References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com>	<fnl35p$hnj$1@ger.gmane.org>	<200801281024.11571.darcyb@commandprompt.com>	<b41c75520801281221i5fbb32f3p1e2f3be40a8dfa74@mail.gmail.com>	<479E3C5E.1070405@FreeBSD.org>	<b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com>	<fnmrri$pi4$1@ger.gmane.org>
	<b41c75520801290146g4e6e2c17oe2fc432245253ba7@mail.gmail.com>
In-Reply-To: <b41c75520801290146g4e6e2c17oe2fc432245253ba7@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-performance@freebsd.org, Ivan Voras <ivoras@freebsd.org>
Subject: Re: postgresql-performance using sysbench
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 30 Jan 2008 09:31:43 -0000

Claus Guttesen wrote:
>>> I forgot to mention in my first post that I'm using ULE. The p800
>>> controller has a (factory set) 25/75 read/write cache ratio.
>> There's maybe one additional thing: do you dual-boot Linux and FreeBSD?
>> If so, you'll need to set up a separate additional partition for the
>> database, instead of benchmarking it with the file systems used by the
>> OS, because different areas of the drive(s) have different performance -
>> you can verify this with diskinfo -t.
> 
> I installed FreeBSD onto a boot-partition (p400i-controller) and used
> the external storage (p800) as database-partition (eight 15K rpm
> sas-disks in raid 1+0). Same with Ubuntu. When I re-installed FreeBSD
> and ubuntu I wiped and formatted the previous partitions. Ubuntu used
> ext3 which I guess is default fs.

Write performance is something that we are working on, expect to hear 
about progress over the coming weeks/months.

Kris