Re: Running on an NFS Mounted Directory - Mailing list pgsql-performance

From Dan Gorman
Subject Re: Running on an NFS Mounted Directory
Date
Msg-id F442345B-2189-4299-9D6F-AE9BC354CB79@hi5.com
Whole thread Raw
In response to Re: Running on an NFS Mounted Directory  (Steve Wampler <swampler@noao.edu>)
List pgsql-performance
We have gotten very good performance from netapp and postgres 7.4.11 .

I was able to push about 100MB/s over gigE, but that was limited by
our netapp.

DAS will generally always be faster, but if for example you have 2
disks vs. 100 NFS mounted ,NFS will be faster.

NFS is very reliable and I would stay away from iscsi.



Regards,
Dan Gorman

On Apr 26, 2006, at 7:35 PM, Steve Wampler wrote:

> 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.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster



pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Running on an NFS Mounted Directory
Next
From: "Guoping Zhang"
Date:
Subject: how unsafe (or worst scenarios) when setting fsync OFF for postgresql