Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread David Miller
Arne Woerner wrote: --- Slawek Zak <[EMAIL PROTECTED]> wrote: On 1/13/06, Arne Woerner <[EMAIL PROTECTED]> wrote: 40MB/s. CPU load negligible. I don't have an exact number, as this machine has other processes running. But overall, the system load didn't exceed 5%. Looks good... I

Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread Arne Woerner
--- Ivan Voras <[EMAIL PROTECTED]> 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 answ

Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread Ivan Voras
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? ___ freebsd-performance@freebsd.org mailing list http://lists.freebsd

Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread Arne Woerner
--- Slawek Zak <[EMAIL PROTECTED]> wrote: > On 1/13/06, Arne Woerner <[EMAIL PROTECTED]> wrote: > 40MB/s. CPU load negligible. I don't have > an exact number, as this machine has other > processes running. But overall, the system > load didn't exceed 5%. > Looks good... > I saturated fast ethernet

Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread Slawek Zak
On 1/13/06, Arne Woerner <[EMAIL PROTECTED]> wrote: > Hiho! > > --- Slawek Zak <[EMAIL PROTECTED]> wrote: > > A couple of days ago I've moved our > > production database from local disks > > to NetAPP filer serving NFS. Performance > > for this server dropped by factor of 10 > > if not more. > > >

Re: Horrible PostgreSQL performance with NFS

2006-01-14 Thread Slawek Zak
On 1/13/06, Claus Guttesen <[EMAIL PROTECTED]> wrote: > > A couple of days ago I've moved our production database from local > > disks to NetAPP filer serving NFS. Performance for this server dropped > > by factor of 10 if not more. From a happy 10% load, the server hit the > > ceiling and sees loa