Re: NFS performance tuning

>>>>> "Scott" == scott marlowe <scott.marlowe@ihs.com> writes:

    Scott> On Sun, 31 Aug 2003, Jefim M wrote:
    >>  I have the following setup for my PostgreSQL box: 4GB Ram Dual
    >> CPU Redhat 7.3 with 2.4.20-18.7smp kernel 2 network cards - one
    >> is dedicated to internal traffic to the NetApp filer and other
    >> is used for other traffic
    >>
    >> and all the Postgres database resides on the NetApp filer using
    >> NFS.  Number of the connection to the database is configured to
    >> 64.
    >>
    >> What are best configuration setting I need to use on my
    >> PostgreSQL and Linux boxes to get the best performance from
    >> PostgresSQL?  Are there any recomendations for the given setup
    >> (having the data on the remote server) ?

    Scott> We use a netapp and I had to muck around with the default
    Scott> settings under rh7.2 to get reliable behaviour.  Note that
    Scott> our database does not sit on a netapp, only our semi-static
    Scott> web content does.

    Scott> Here's the settings I added, at the behest of one of our
    Scott> unix / linux ubergeeks:

    Scott> timeo=10,retry=1,bg,soft,intr,rsize=8192,wsize=8192

Argh, don't use soft mounting when the database is being accessed
through NFS and you value your data. Check out nfs.sf.net, there is a
HOWTO and FAQ for Linux NFS issues. netapp also has a very good
LInux/Netapp document written by a netapp employee who also hacks the
Linux kernel client. A google on "netapp linux howto" should find it
easily enough.

Sincerely,

Adrian Phillips

--
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/