From owner-freebsd-performance@FreeBSD.ORG Tue Jan 29 09:47:13 2008 Return-Path: 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 594D416A420 for ; Tue, 29 Jan 2008 09:47:13 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by mx1.freebsd.org (Postfix) with ESMTP id 1148D13C4E5 for ; Tue, 29 Jan 2008 09:47:12 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so541961anc.13 for ; Tue, 29 Jan 2008 01:47:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ng39Mc4/dxOO9oWTgEWSbJjEbmYUa5+5aN4fMI4wKs8=; b=LvonHiMZHPPCUX+UFrYfHtYs3jDzXWizl5sxwAgL0NnCYkDzC3S75zZiNOf+7SsYaAiwsnZjxAOhBUhPj5o3yENonA/MGcvD9UAeDs9cdNJruE0SzRjppDs4CCxwrwQAL/+q0nLcVbNY0Ui5b9fZ8+Wx6dMdLwx0afPxsyva6Qg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=A5B+edldDJnGA8+sYI8rgZ1k6ZFmSmwFz8WuzeTNmrTCeXLhNnrFsM1VgRMtLZzBsLUIqoVPV25Qt37zZobTmnQP7I2d/g1mJlHkJreCZA7w/X6QT2iU0uzZFp1YBy8ShZymUa9Z7TnmmhvVXR3Tkm0HQv8iqm0EEzN3mBsXpew= Received: by 10.100.201.16 with SMTP id y16mr14312004anf.30.1201600007813; Tue, 29 Jan 2008 01:46:47 -0800 (PST) Received: by 10.100.242.10 with HTTP; Tue, 29 Jan 2008 01:46:47 -0800 (PST) Message-ID: Date: Tue, 29 Jan 2008 10:46:47 +0100 From: "Claus Guttesen" To: "Ivan Voras" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200801281024.11571.darcyb@commandprompt.com> <479E3C5E.1070405@FreeBSD.org> Cc: freebsd-performance@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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Jan 2008 09:47:13 -0000 > > 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. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare