Re: Horrible PostgreSQL performance with NFS

2006-01-13 Thread Claus Guttesen
> 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 load of 100% all the time with runqueue above 30. The > > I can p

Re: Horrible PostgreSQL performance with NFS

2006-01-13 Thread Brooks Davis
On Fri, Jan 13, 2006 at 01:10:48PM -0800, Arne Woerner 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 m

Re: Horrible PostgreSQL performance with NFS

2006-01-13 Thread Arne Woerner
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. > I would like to suggest some tests (I do not have a clear idea, why you

Horrible PostgreSQL performance with NFS

2006-01-13 Thread Slawek Zak
Hello everyone, 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 load of 100% all the time with runqueue above 30. The se