From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'John R Pierce *EXTERN*'" <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: can postgres run well on NFS mounted partitions? |
Date: | 2015-11-11 09:45:28 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B50FE2E46@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mammarelli, Joanne T | 2015-11-11 12:53:58 | Re: attempting to install tds_fw-master on redhat |
Previous Message | Dusan | 2015-11-11 09:44:16 | recursive table performance (CTE) |