From owner-freebsd-database@FreeBSD.ORG  Thu Jan 19 00:59:00 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 51BA216A420;
	Thu, 19 Jan 2006 00:59:00 +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 E5A7143D45;
	Thu, 19 Jan 2006 00:58:59 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id 3EDBC3983D; Wed, 18 Jan 2006 18:58:47 -0600 (CST)
Date: Wed, 18 Jan 2006 18:58:47 -0600
From: "Jim C. Nasby" <decibel@decibel.org>
To: Arne Woerner <arne_woerner@yahoo.com>
Message-ID: <20060119005847.GK17896@decibel.org>
References: <787bbe1c0601140457y6de99891n86b49a728eedac94@mail.gmail.com>
	<20060114144202.6199.qmail@web30315.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20060114144202.6199.qmail@web30315.mail.mud.yahoo.com>
X-Operating-System: FreeBSD 6.0-RELEASE amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.11
Cc: freebsd-database@freebsd.org, freebsd-performance@freebsd.org
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, 19 Jan 2006 00:59:00 -0000

On Sat, Jan 14, 2006 at 06:42:02AM -0800, Arne Woerner wrote:
> Did you do those "dd" tests with small block sizes (like 1byte:
> bs=1), like somebody on one of those lists suggests, too? Then we
> could see, if there is a high latency that ruins everything...

FYI, PostgreSQL does 8kB I/O by default. This can only be changed by
modifying a header file.
-- 
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?"