Horrible PostgreSQL performance with NFS
slawek.zak at gmail.com
Sun Jan 15 06:50:51 PST 2006
On 1/14/06, Arne Woerner <arne_woerner at yahoo.com> wrote:
> --- Ivan Voras <ivoras at 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
> 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>
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ławek Żak / UNIX Systems Administrator
More information about the freebsd-performance