NFS, file system cache and shared_buffers - Mailing list pgsql-performance

From Albe Laurenz
Subject NFS, file system cache and shared_buffers
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17CFE61C@ntex2010i.host.magwien.gv.at
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Profiling PostgreSQL
Next
From: Heikki Linnakangas
Date:
Subject: Re: NFS, file system cache and shared_buffers