Re: [sfpug] DATA directory on network attached storage - Mailing list pgsql-performance

From Joe Conway
Subject Re: [sfpug] DATA directory on network attached storage
Date
Msg-id 425ABB17.305@joeconway.com
Whole thread Raw
In response to Re: [sfpug] DATA directory on network attached storage  (Aditya <aditya@grot.org>)
Responses Re: [sfpug] DATA directory on network attached storage
List pgsql-performance
Aditya wrote:
> We have not, AFAICT, had any problems with the traffic over NFS as far as
> reliability -- I'm sure there is a performance penalty, but the reliability
> and scalability gains more than offset that.

My experience agrees with yours. However we did find one gotcha -- see
the thread starting here for details:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00479.php

In a nutshell, be careful when using an nfs mounted data directory
combined with an init script that creates a new data dir when it doesn't
find one.

> FWIW, if I were to do this anew, I would probably opt for iSCSI over GigE with
> a NetApp.

Any particular reason? Our NetApp technical rep advised nfs over iSCSI,
IIRC because of performance.

Joe

pgsql-performance by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Is there somthing I need to do on my production server?
Next
From: "Joel Fradkin"
Date:
Subject: Re: Is there somthing I need to do on my production server?