X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0B8AD537FE; Mon, 11 Apr 2005 17:17:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60924-03; Mon, 11 Apr 2005 20:17:34 +0000 (GMT) Received: from joeconway.com (wsip-24-249-201-67.sd.sd.cox.net [24.249.201.67]) by svr1.postgresql.org (Postfix) with ESMTP id 6DCBA536E7; Mon, 11 Apr 2005 17:17:33 -0300 (ADT) Received: from [206.19.64.3] (account jconway HELO [172.16.1.115]) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 2746794; Mon, 11 Apr 2005 14:16:40 -0700 Message-ID: <425ADB5E.7060007@joeconway.com> Date: Mon, 11 Apr 2005 13:17:34 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.7.6) Gecko/20050323 Fedora/1.7.6-1.3.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Aditya Cc: Jeff Frost , Josh Berkus , sfpug@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [sfpug] DATA directory on network attached storage References: <200502091350.24885.josh@agliodbs.com> <20050408192136.GD72199@mighty.grot.org> <425ABB17.305@joeconway.com> <20050411182032.GA48183@mighty.grot.org> In-Reply-To: <20050411182032.GA48183@mighty.grot.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/220 X-Sequence-Number: 11617 Aditya wrote: > On Mon, Apr 11, 2005 at 10:59:51AM -0700, Joe Conway wrote: >>Any particular reason? Our NetApp technical rep advised nfs over iSCSI, >>IIRC because of performance. > > I would mount the Netapp volume(s) as a block level device on my server using > iSCSI (vs. a file-based device like NFS) so that filesystem parameters could > be more finely tuned and one could really make use of jumbo frames over GigE. Actually, we're using jumbo frames over GigE with nfs too. > I'm not sure I understand why NFS would perform better than iSCSI -- in any > case, some large Oracle dbs at my current job are moving to iSCSI on Netapp > and in that environment both Oracle and Netapp advise iSCSI (probably because > Oracle uses the block-level device directly), so I suspend the difference in > performance is minimal. We also have Oracle DBs via nfs mounted Netapp, again per the local guru's advice. It might be one of those things that is still being debated even within Netapp's ranks (or maybe our info is dated - worth a check). Thanks, Joe