From owner-freebsd-performance@FreeBSD.ORG  Sat Jan 14 14:58:40 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: 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 DCF3A16A41F
	for <freebsd-performance@freebsd.org>;
	Sat, 14 Jan 2006 14:58:40 +0000 (GMT) (envelope-from ivoras@fer.hr)
Received: from pinus.cc.fer.hr (pinus.cc.fer.hr [161.53.73.18])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0E56543D48
	for <freebsd-performance@freebsd.org>;
	Sat, 14 Jan 2006 14:58:38 +0000 (GMT) (envelope-from ivoras@fer.hr)
Received: from [161.53.72.113] (lara.cc.fer.hr [161.53.72.113])
	by pinus.cc.fer.hr (8.12.2/8.12.2) with ESMTP id k0EEwUFx008381;
	Sat, 14 Jan 2006 15:58:30 +0100 (MET)
Message-ID: <43C9110B.8070807@fer.hr>
Date: Sat, 14 Jan 2006 15:56:11 +0100
From: Ivan Voras <ivoras@fer.hr>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050921)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Arne Woerner <arne_woerner@yahoo.com>, freebsd-performance@freebsd.org
References: <787bbe1c0601140457y6de99891n86b49a728eedac94@mail.gmail.com>
	<20060114144202.6199.qmail@web30315.mail.mud.yahoo.com>
In-Reply-To: <20060114144202.6199.qmail@web30315.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: 
Subject: Re: Horrible PostgreSQL performance with NFS
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
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: Sat, 14 Jan 2006 14:58:41 -0000

Arne Woerner wrote:

> But why does switching from local disc to NFS makes the PostgreSQL
> performance so bad?

A wild guess/try: does file locking work properly with NFS and the filer?