From: David Boreham <david_list@boreham.org>
To: pgsql-performance@postgresql.org
Subject: Re: NFS, file system cache and shared_buffers
Date: Tue, 27 May 2014 09:18:47 -0600
Message-ID: <5384ACD7.3090208@boreham.org> (raw)
In-Reply-To: <5384AAB5.6030307@optionshouse.com>
References: <A737B7A37273E048B164557ADEF4A58B17CFE61C@ntex2010i.host.magwien.gv.at>
<53848490.6060001@vmware.com>
<20140527144013.GL2556@tamriel.snowman.net>
<A737B7A37273E048B164557ADEF4A58B17CFE7B0@ntex2010i.host.magwien.gv.at>
<5384AAB5.6030307@optionshouse.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 5/27/2014 9:09 AM, Shaun Thomas wrote:
> On 05/27/2014 10:00 AM, Albe Laurenz wrote:
>
>> I know that Oracle recommends it - they even built an NFS client
>> into their database server to make the most of it.
>
> That's odd. Every time the subject of NFS comes up, it's almost
> immediately shot down with explicit advice to Never Do That(tm). It
> can be kinda safe-ish if mounted in sync mode with caching disabled,
> but I'd never use it on any of our systems.
It has been a long time since I was in the weeds of this issue, but the
crux is that it was (still is?) hard to be sure that the filesystem's
behavior was exactly as expected. My recollection of the Oracle story
was that they had to verify the end-to-end behavior, and essentially
certify its correctness to guarantee database acid. So you needed to be
running a very specific version of the NFS code, configured in a very
specific way. This isn't entirely inconsistent with the reference above
that they "built an NFS client". That's something you might need to do
in order to be sure it behaves in the way you expect. Possibly the NFS
implementations deployed today are more consistent and correct than was
the case in the past. I wouldn't use a network filesystem for any kind
of database storage myself though.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: david_list@boreham.org
Subject: Re: NFS, file system cache and shared_buffers
In-Reply-To: <5384ACD7.3090208@boreham.org>
* 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