From owner-freebsd-database@FreeBSD.ORG Fri Jan 13 21:10:50 2006 Return-Path: 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 6764A16A420 for ; Fri, 13 Jan 2006 21:10:50 +0000 (GMT) (envelope-from arne_woerner@yahoo.com) Received: from web30313.mail.mud.yahoo.com (web30313.mail.mud.yahoo.com [68.142.201.231]) by mx1.FreeBSD.org (Postfix) with SMTP id 649F743D49 for ; Fri, 13 Jan 2006 21:10:49 +0000 (GMT) (envelope-from arne_woerner@yahoo.com) Received: (qmail 31787 invoked by uid 60001); 13 Jan 2006 21:10:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=iEszZWXAynBg8QhAwKJkQLr828pfnzM2QRLsad658xg8jAdi4NvrSZhO9lL9ywDrAzWbuKjdVL9BaESRHnxTB4PyqKOCTZqrDY0F83J2F/woh4kxsQFnZZRqn/Hh+Xc5um4eqEeD9bsLvqiCWZu5kVLzi8NwMtsfksN8TcbtTyA= ; Message-ID: <20060113211048.31785.qmail@web30313.mail.mud.yahoo.com> Received: from [213.54.85.246] by web30313.mail.mud.yahoo.com via HTTP; Fri, 13 Jan 2006 13:10:48 PST Date: Fri, 13 Jan 2006 13:10:48 -0800 (PST) From: Arne Woerner To: Slawek Zak , freebsd-database@freebsd.org, freebsd-performance@freebsd.org In-Reply-To: <787bbe1c0601131220j7b3a052ege5fe4683156312a7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Jan 2006 21:10:50 -0000 Hiho! --- Slawek Zak wrote: > 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. > I would like to suggest some tests (I do not have a clear idea, why your system becomes slower; a hypothesis will follow below): 1. benchmark the local disc (watch cpu usage via e. g. vmstat 1) % dd if=/dev/zero of=/some/local/filesystem/a bs=1m count=1000 2. benchmark the NFS filesystem (watch cpu usage via e. g. vmstat 1) % dd if=/dev/zero of=/some/NFS/filesystem/a bs=1m count=1000 3. test the NIC performance with (again watching the CPU usage might help) % ping -s 50000 I get 17Mbit/sec which is the actual rate... neo# ping -s 50000 vaako PING vaako.riddick.homeunix.org (10.1.1.3): 50000 data bytes 50008 bytes from 10.1.1.3: icmp_seq=0 ttl=64 time=46.584 ms My theory would be, that your NICs need a lot of CPU time, while your local discs dont need so much CPU time. :-) Bye Arne __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com