From owner-freebsd-database@FreeBSD.ORG  Thu Feb  9 06:58:05 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@FreeBSD.ORG
Delivered-To: freebsd-database@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 42F2916A420
	for <freebsd-database@FreeBSD.ORG>;
	Thu,  9 Feb 2006 06:58:05 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C383643D46
	for <freebsd-database@FreeBSD.ORG>;
	Thu,  9 Feb 2006 06:58:02 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id 1AC8239842; Thu,  9 Feb 2006 06:57:52 +0000 (UTC)
Received: (hashcash-sendmail, from uid 1001);
	Thu, 9 Feb 2006 00:57:51 -0600
Date: Thu, 9 Feb 2006 00:57:51 -0600
From: "Jim C. Nasby" <decibel@decibel.org>
To: freebsd-database@FreeBSD.ORG
Message-ID: <20060209065751.GA57845@decibel.org>
References: <20060119011550.GN17896@decibel.org>
	<200601221049.k0MAnaVh089477@lurza.secnetix.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200601221049.k0MAnaVh089477@lurza.secnetix.de>
X-Operating-System: FreeBSD 6.0-RELEASE amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.11
X-Hashcash: 1:20:060209:freebsd-database@freebsd.org::ROn9qqFQ6BSF2fHw:000000000
	0000000000000000000000007rXK
Cc: 
Subject: Re: Horrible PostgreSQL performance with NFS
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 09 Feb 2006 06:58:05 -0000

On Sun, Jan 22, 2006 at 11:49:36AM +0100, Oliver Fromme wrote:
> FWIW, there is _no_ blocksize that can be used wit dd(1)
> that benchmarks disks the same way a database does.
> Unless our dd(1) implemetation grew a random-seek option
> that I missed.  :-)
> 
> But seriously...  dd(1) is NOT a benchmark.  Never ever.
> Especially if you're interested in database performance.

OLAP databases depend heavily on sequential scans, which are the same as
dd. dd is also useful to find out what your maximum throughput is.
-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"