Re: can postgres run well on NFS mounted partitions?

John R Pierce wrote:
> On 11/11/2015 12:37 AM, Albe Laurenz wrote:
> > It would be good to know of other pitfalls; I (and no doubt not only I)
> > keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle
> > has no problem with it (and don't tell me that Oracle does not care
> > about data corruption).
>
> Last I looked, Oracle had a very specific set of recommendations for
> qualified NFS storage. Like, NetApp Filers, with everything setup
> just so.

I had heard that before, so I looked and could not find any information
which NFS devices are supported. All you read is:
(http://docs.oracle.com/cd/E11882_01/install.112/e47689/app_nas.htm#LADBI1366)

Before using the NAS device for the installation, verify that it is certified.
For certification information refer to note 359515.1 on the My Oracle Support website

I did, and all that contains is a list of mount options you have to use, e.g.
for x86-64 Linux
rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
(the "bg" weirds me out)

So I opened a service request about a year ago and asked them *what* NFS
storage is supported.

The answer (in unquotable English) was that it didn't matter what the
NFS server was, as long as the NFS client is on a UNIX/Linux certified for Oracle
database and you use the right mount options.
At least that's what I understood ...

Yours,
Laurenz Albe