Re: Horrible PostgreSQL performance with NFS

--- 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

appendix A: the script lck-tst.sh
#!/bin/sh

lockf -k $1 sleep 10 &
sleep 3
lockf -k -s -t 0 $1 echo BAD || echo GOOD
wait

sts=`date +%s`
i=0
while [ $i -lt 2000 ]; do
i=`expr $i + 1`
lockf -k $1 sleep 0 &
done
expr `date +%s` - $sts


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: mount/export network file system
    ... nfs export still does not working. ... to do someting on iptables or firewall setting. ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (Fedora)
  • configuring nfs - portmap failure
    ... I am trying to configure nfs. ... I have the following entry in /etc/exports ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (RedHat)
  • FTP Automate Shell Script
    ... am following a tutorial to create a shell script to ... Here is the script - ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (freebsd-questions)
  • Re: This is a cool shell prompt question
    ... you can use some small shell script to run as getty replacement? ... >find it cool to have a huge digital clock ... >Do You Yahoo!? ... Mail has the best spam protection around ...
    (freebsd-questions)
  • [SLE] Noob question about file icons on the desktop
    ... I was wondering in windows when you change an icon for ... I put a link to a shell script ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (SuSE)