Date: Sat, 14 Jan 2006 08:14:02 -0800 (PST) From: Arne Woerner <arne_woerner@yahoo.com> To: Ivan Voras <ivoras@fer.hr>, freebsd-performance@freebsd.org, slawek.zak@gmail.com Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <20060114161402.43003.qmail@web30305.mail.mud.yahoo.com> In-Reply-To: <43C9110B.8070807@fer.hr>
next in thread | previous in thread | raw e-mail | index | archive | help
--- Ivan Voras <ivoras@fer.hr> wrote: > Arne Woerner wrote: > > But why does switching from local disc > > to NFS makes the PostgreSQL performance > > so bad? > > A wild guess/try: does file locking work > properly with NFS and the filer? > I would recommend the following test in order to answer that question: Executing the shell script in appendix A of this email will test, if locking works, and how fast it is: % time ./lck-tst.sh </path/to/local-fs/file> % time ./lck-tst.sh </path/to/NFS/file> -Arne appendix A: the script lck-tst.sh #!/bin/sh lockf -k $1 sleep 10 & sleep 3 lockf -k -s -t 0 $1 echo BAD || echo GOOD wait sts=`date +%s` i=0 while [ $i -lt 2000 ]; do i=`expr $i + 1` lockf -k $1 sleep 0 & done expr `date +%s` - $sts __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060114161402.43003.qmail>