[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Horrible PostgreSQL performance with NFS
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
> 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