Re: Horrible PostgreSQL performance with NFS

[Slawek Zak <slawek_(_dot_)_zak_(_at_)_gmail_(_dot_)_com>]

On 1/14/06, Arne Woerner <arne_woerner_(_at_)_yahoo_(_dot_)_com> wrote:
> --- Ivan Voras <ivoras_(_at_)_fer_(_dot_)_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

_______________________________________________
freebsd-database_(_at_)_freebsd_(_dot_)_org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe_(_at_)_freebsd_(_dot_)_org"