Re: NFS performance tuning
От | Adrian Phillips |
---|---|
Тема | Re: NFS performance tuning |
Дата | |
Msg-id | 87ptidcdee.fsf@grannyogg.localnet обсуждение исходный текст |
Ответ на | Re: NFS performance tuning ("scott.marlowe" <scott.marlowe@ihs.com>) |
Ответы |
Re: NFS performance tuning
|
Список | pgsql-general |
>>>>> "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/
В списке pgsql-general по дате отправления: