Re: Horrible PostgreSQL performance with NFS
Slawek Zak <[email protected]>
| Newsgroups | gmane.os.freebsd.performance,gmane.os.freebsd.devel.database |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[email protected]"