From: Bryan Keller <bryanck@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres on NAS/NFS
Date: Mon, 14 Feb 2011 10:05:43 -0800
Message-ID: <E52993F4-A49C-4610-A10D-BFE01545987D@gmail.com> (raw)
In-Reply-To: <AANLkTin8PyrBW4cG__Vmas2+cNB+hWRghULChspt+sxt@mail.gmail.com>
References: <9424C7B4-672D-4C64-BE6A-699708981C0B@gmail.com>
<AANLkTin8PyrBW4cG__Vmas2+cNB+hWRghULChspt+sxt@mail.gmail.com>
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@gmail.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@stuartbishop.net>
> http://www.stuartbishop.net/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bryanck@gmail.com
Subject: Re: Postgres on NAS/NFS
In-Reply-To: <E52993F4-A49C-4610-A10D-BFE01545987D@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox