Re: can postgres run well on NFS mounted partitions?

Поиск
Список
Период
Сортировка
От anj patnaik
Тема Re: can postgres run well on NFS mounted partitions?
Дата
Msg-id CAEQKwSmXC2xX+zFbp2p4sDroK-vcdrg9mmVrTvUsb1wCvGLq8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: can postgres run well on NFS mounted partitions?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: can postgres run well on NFS mounted partitions?  (Scott Mead <scottm@openscg.com>)
Re: can postgres run well on NFS mounted partitions?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Дерево обсуждения
Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11) and Postgres 9.4. I ran some insertions today from a client running on Windows. The client does a loop of 30 updates. 

I am seeing about 10-20% increase in latency in the case where DB is on NFS (over TCP) compared to directly on disk.

The other machine I am using to compare is running RHEL 6.5 and Postgres 9.4.

Are there any specific tests that are recommended to test that postgres over NFS works well?

I am planning on doing a few large data inserts and fetches. 

With the little testing, the DB over NFS appears fine.


Thanks for any feedback.

On Tue, Nov 10, 2015 at 4:29 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
anj patnaik wrote:
> Can anyone advise if there are problems running postgres over NFS mounted partitions?
>
> I do need reliability and high speed.

I have got the advice not to use NFS from a number of people who should know,
but there are also knowledgable people who use PostgreSQL with NFS.

You need hard foreground mounts, and you need an NFS server that is
guaranteed not to lose data that the client has synced to disk.

You should probably only consider storage systems that directly
support NFS, and you should run performance and reliability tests.

Yours,
Laurenz Albe

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: attempting to install tds_fw-master on redhat
Следующее
От: Scott Mead
Дата:
Сообщение: Re: can postgres run well on NFS mounted partitions?