X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1630711F60E8 for ; Thu, 27 Apr 2006 00:36:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 67794-05 for ; Thu, 27 Apr 2006 00:35:51 -0300 (ADT) X-Greylist: delayed 01:00:08.878658 by SQLgrey- Received: from noao.edu (noao.edu [140.252.1.54]) by postgresql.org (Postfix) with ESMTP id 2619211F60E5 for ; Thu, 27 Apr 2006 00:35:50 -0300 (ADT) X-TFF-CGPSA-Version: 1.4f1 X-TFF-CGPSA-Filter: Scanned Received: from weaver.tuc.noao.edu ([140.252.14.8] verified) by noao.edu (CommuniGate Pro SMTP 5.0.9) with ESMTPS id 25881248; Wed, 26 Apr 2006 19:35:42 -0700 Received: from weaver.tuc.noao.edu (localhost.localdomain [127.0.0.1]) by weaver.tuc.noao.edu (8.13.1/8.13.1) with ESMTP id k3R2Zg0p014715; Wed, 26 Apr 2006 19:35:42 -0700 Received: (from swampler@localhost) by weaver.tuc.noao.edu (8.13.1/8.13.1/Submit) id k3R2ZgDg014714; Wed, 26 Apr 2006 19:35:42 -0700 Date: Wed, 26 Apr 2006 19:35:42 -0700 From: Steve Wampler To: Ketema Harris Cc: pgsql-performance@postgresql.org Subject: Re: Running on an NFS Mounted Directory Message-ID: <20060427023542.GA14672@weaver.tuc.noao.edu> Reply-To: swampler@noao.edu References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/624 X-Sequence-Number: 18708 On Wed, Apr 26, 2006 at 10:06:58PM -0400, Ketema Harris wrote: > I was wondering if there were any performance issues with having a data > directory that was an nfs mounted drive? Say like a SAN or NAS device? Has > anyone done this before? My understanding is that NFS is pretty poor in performance in general, so I would expect it to be particularly bad for a DB. You might run some (non-DB) performance tests to get a feel for how bad it might me. (Someone once told me that NFS topped out at around 12MB/s, but I don't know if that's really true [they were trying to sell a competitive networked filesystem]). In any event, you're at least limited by ethernet speeds, if not more. -- Steve Wampler -- swampler@noao.edu The gods that smiled on your birth are now laughing out loud.