Re: can postgres run well on NFS mounted partitions?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: can postgres run well on NFS mounted partitions?
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B50FE2E46@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: can postgres run well on NFS mounted partitions?  (John R Pierce <pierce@hogranch.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dusan
Дата:
Сообщение: recursive table performance (CTE)
Следующее
От: "Mammarelli, Joanne T"
Дата:
Сообщение: Re: attempting to install tds_fw-master on redhat