Date: Sun, 15 Jan 2006 15:50:49 +0100 From: Slawek Zak <slawek.zak@gmail.com> To: Arne Woerner <arne_woerner@yahoo.com>, freebsd-performance@freebsd.org, freebsd-database@freebsd.org Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <787bbe1c0601150650n664f8114o89ea37bf50e7dac7@mail.gmail.com> In-Reply-To: <20060114161402.43003.qmail@web30305.mail.mud.yahoo.com> References: <43C9110B.8070807@fer.hr> <20060114161402.43003.qmail@web30305.mail.mud.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 1/14/06, Arne Woerner <arne_woerner@yahoo.com> wrote: > --- 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 [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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?787bbe1c0601150650n664f8114o89ea37bf50e7dac7>