From owner-freebsd-database@FreeBSD.ORG  Fri Jan 13 22:15:34 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 EF8E016A420
	for <freebsd-database@freebsd.org>;
	Fri, 13 Jan 2006 22:15:34 +0000 (GMT)
	(envelope-from kometen@gmail.com)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 10C8D43D45
	for <freebsd-database@freebsd.org>;
	Fri, 13 Jan 2006 22:15:33 +0000 (GMT)
	(envelope-from kometen@gmail.com)
Received: by wproxy.gmail.com with SMTP id 71so740097wra
	for <freebsd-database@freebsd.org>;
	Fri, 13 Jan 2006 14:15:33 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=icCdC6jyAW7R2ZlIioUOyB3YWtfw7KhN51PT0e8vuQgWX7z03hAwWouKimxhlYlcSeoHPy/Hbge8RIWzmnEUFNelc6ez4NNLph0jAODBXHz62/Rl81LpE5iOxwR3p+ovicrGjuiM/lgFVxweoBEoazZavtXH4Kt3YL0bFXwAXAE=
Received: by 10.65.218.4 with SMTP id v4mr2120984qbq;
	Fri, 13 Jan 2006 14:15:33 -0800 (PST)
Received: by 10.65.192.14 with HTTP; Fri, 13 Jan 2006 14:15:33 -0800 (PST)
Message-ID: <b41c75520601131415u36e2006es@mail.gmail.com>
Date: Fri, 13 Jan 2006 23:15:33 +0100
From: Claus Guttesen <kometen@gmail.com>
To: Slawek Zak <slawek.zak@gmail.com>
In-Reply-To: <787bbe1c0601131220j7b3a052ege5fe4683156312a7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <787bbe1c0601131220j7b3a052ege5fe4683156312a7@mail.gmail.com>
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: Fri, 13 Jan 2006 22:15:35 -0000

> A couple of days ago I've moved our production database from local
> disks to NetAPP filer serving NFS. Performance for this server dropped
> by factor of 10 if not more. From a happy 10% load, the server hit the
> ceiling and sees load of 100% all the time with runqueue above 30. The
>
> I can provide postgresql config. Sysctl knobs remain untouched not
> counting basic NFS tweaking. For mount_nfs I tried to change NFS
> buffer sizes -r -w. I also tried the -L option to keep the lock
> traffic local. On the postgres side, setting fsync =3D off in
> postgresql.conf. It didn't change a thing.

Did you try tcp?

regards
Claus