Re: NFS, file system cache and shared_buffers

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: NFS, file system cache and shared_buffers
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17CFEA12@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: NFS, file system cache and shared_buffers  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: NFS, file system cache and shared_buffers  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-performance
Jeff Janes wrote:
>>> All that said, there has always been a recommendation of caution around
>>> using NFS as a backing store for PG, or any RDBMS..
>> 
>>     I know that Oracle recommends it - they even built an NFS client
>>     into their database server to make the most of it.
> 
> Last I heard (which has been a while), Oracle supported specific brand named implementations of NFS,
> and warned against any others on a data integrity basis.

I couldn't find any detailed information, but it seems that only certain
NFS devices are supported.

> Why would they implement their own client?  Did they have to do something special in their client to
> make it safe?

I think it is mostly a performance issue.  Each backend mounts its own copy
of the data files it needs.

Yours,
Laurenz Albe

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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: NFS, file system cache and shared_buffers
Следующее
От: Grzegorz Olszewski
Дата:
Сообщение: Re: Planner doesn't take indexes into account