--- Ivan Voras <[EMAIL PROTECTED]> 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 _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[EMAIL PROTECTED]"