Re: Postgres on NAS/NFS

Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to database I/O.

On Feb 14, 2011, at 2:07 AM, Stuart Bishop wrote:

> On Thu, Feb 10, 2011 at 2:59 AM, Bryan Keller <bryanck(at)gmail(dot)com> wrote:
>
>> I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption.
>
> Its not recommended if you have a crap NFS implementation. I think it
> was about 10 years ago I ran Oracle under Solaris with a Netapp for
> storage. Rock solid, supported configuration, and actually
> outperformed using local disk. Hopefully the open source NFS clients
> have caught up by now - if you see problem reports or recommendations,
> pay attention to the platform and implementation rather than the
> protocol.
>
>
> --
> Stuart Bishop <stuart(at)stuartbishop(dot)net>
> http://www.stuartbishop.net/