I don't know BSD too well, but do you have the local-lock NFS mount option ?
There is generally no need for file locks to propagate over the network if the share is dedicated to a single server. Let the local kernel handle it instead. This has worked for me in the past for an old C-ISAM app on Solaris.
Look at nfsstat output on the filer and see if you have lots of small (512b) requests.
hth
D #
----- Original Message ----- From: "'Aditya '" aditya@grot.org To: "Maxwell Reid" MReid@marshall-swift.com Cc: toasters@mathworks.com Sent: Tuesday, September 16, 2003 12:04 AM Subject: Re: Running Postgresql with db on Netapp
On Mon, Sep 15, 2003 at 03:41:28PM -0700, Maxwell Reid wrote:
Is it possible to install a Gigabit adapter in the *BSD box and filer? That alone will probably give you a good performance boost... Switching
to
udp probably won't improve things, but using Gbe and jumbo frames will
do
wonders.
I'd consider that, however I'm having a hard time believing that a PC a *stinkeen* plain-ol-IDE drive is doing better than my filer.
I can blame (in order of cost of upgrade):
- a configuration mistake
- mount options
- filer options
- network hardware
- nfs
- pc hardware
- postgresql
and I'm slowly working my way down that list...(grin)
I suspect that folks running Oracle/Informix with a filer aren't seeing
more
than a 10% performance reduction, otherwise very few would opt to do it,
so I
suspect that it works, it works well and I must be missing something...
Thanks, Adi
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 28/08/2003