Re: Horrible PostgreSQL performance with NFS

[Slawek Zak <slawek.zak@xxxxxxxxx>]

On 1/14/06, Arne Woerner <arne_woerner@xxxxxxxxx> wrote:
> --- Ivan Voras <ivoras@xxxxxx> 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