From owner-freebsd-performance@FreeBSD.ORG  Thu Aug 28 13:40:37 2003
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 02F8516A4DE
	for <freebsd-performance@freebsd.org>;
	Thu, 28 Aug 2003 13:40:37 -0700 (PDT)
Received: from web14102.mail.yahoo.com (web14102.mail.yahoo.com
	[216.136.172.132])
	by mx1.FreeBSD.org (Postfix) with SMTP id 709B943FEA
	for <freebsd-performance@freebsd.org>;
	Thu, 28 Aug 2003 13:40:32 -0700 (PDT)
	(envelope-from cguttesen@yahoo.dk)
Message-ID: <20030828204032.97741.qmail@web14102.mail.yahoo.com>
Received: from [194.248.174.58] by web14102.mail.yahoo.com via HTTP;
	Thu, 28 Aug 2003 22:40:32 CEST
Date: Thu, 28 Aug 2003 22:40:32 +0200 (CEST)
From: =?iso-8859-1?q?Claus=20Guttesen?= <cguttesen@yahoo.dk>
To: Sean Chittenden <seanc@FreeBSD.org>,
	Robert Watson <rwatson@freebsd.org>,
	Bill Moran <wmoran@potentialtech.com>, freebsd-database@freebsd.org,
	freebsd-fs@freebsd.org, freebsd-performance@freebsd.org
In-Reply-To: <20030828171955.GE83759@perrin.nxad.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Subject: Re: Some additional tests run on my performance testing
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.1
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: Thu, 28 Aug 2003 20:40:37 -0000

Hi.

I'm implementing postgresql 7.3.4 on FreeBSD 5.1, and
decided to place the pgsql-folder on it's own
partition so it was easier to test which blocksize to
go for.

So I newfs'ed it with 8 and 16 kb blocksize did an
import of a 1.5 GB pg-dump.

> numbers you suggest above, I loaded a DB with 8k and
> 16K blocks
> (translation: almost all write activities).
> 
> them to stay about the same across the board.  If
> someone wants to do
> some good read tests, I'd be interested in those
> results.
> 

The 8 kb blocksize took 60 min. to import, and the 16
kb ditto took 45 min. So I'm settling on 16 kb blocks.

Softupdates was enabled in both scenarios, db was
dropped and recreated and server rebooted before each
import. The fragsize was the recommended 1/8 of
blocksize, i.e. 1 and 2 kb. 2 GB ECC RAM.

I haven't done any further testing than that, but it
seems that FreeBSD internally caches 16 kb blocksize
better than 8 kb.

regards
Claus

Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads, spamfilter og virusscan