Re: [sfpug] DATA directory on network attached storage

From: Joe Conway <mail(at)joeconway(dot)com>
To: Aditya <aditya(at)grot(dot)org>
Cc: Jeff Frost <jeff(at)frostconsultingllc(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, sfpug(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [sfpug] DATA directory on network attached storage
Date: 2005-04-11 20:17:34
Message-ID: 425ADB5E.7060007@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance sfpug

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Keith Worthington 2005-04-12 00:43:46 Re: 4 way JOIN using aliases
Previous Message Joel Fradkin 2005-04-11 18:29:22 Re: Is there somthing I need to do on my production server?

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2005-04-11 21:24:59 PostgreSQL Job Opportunity
Previous Message Craig Addleman 2005-04-11 18:33:24 Re: Need RSVPs, meeting tommorrow.