NFS, file system cache and shared_buffers

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема NFS, file system cache and shared_buffers
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17CFE61C@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответы Re: NFS, file system cache and shared_buffers  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Re: NFS, file system cache and shared_buffers  (Jeff Janes <jeff.janes@gmail.com>)
Re: NFS, file system cache and shared_buffers  (John Melesky <john.melesky@rentrakmail.com>)
Список pgsql-performance
I just learned that NFS does not use a file system cache on the client side.

On the other hand, PostgreSQL relies on the file system cache for performance,
because beyond a certain amount of shared_buffers performance will suffer.

Together these things seem to indicate that you cannot get good performance
with a large database over NFS since you can leverage memory speed.

Now I wonder if there are any remedies (CacheFS?) and what experiences
people have made with the performance of large databases over NFS.

Yours,
Laurenz Albe

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

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: Profiling PostgreSQL
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: NFS, file system cache and shared_buffers