On 1/14/06, Arne Woerner <[EMAIL PROTECTED]> wrote: > --- 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 [snip]
I keep the locks local with mount_nfs -L, so it's not a problem. I don't know if postgresql uses file locking anyway. /S -- Sławek Żak / UNIX Systems Administrator
_______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[EMAIL PROTECTED]"