Re: Horrible PostgreSQL performance with NFS
Slawek Zak <[email protected]>
| Newsgroups | gmane.os.freebsd.devel.database,gmane.os.freebsd.performance |
|---|---|
| Message-ID | <[email protected]> |
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 load of 100% all the time with runqueue above 30. The > > > > I can provide postgresql config. Sysctl knobs remain untouched not > > counting basic NFS tweaking. For mount_nfs I tried to change NFS > > buffer sizes -r -w. I also tried the -L option to keep the lock > > traffic local. On the postgres side, setting fsync = off in > > postgresql.conf. It didn't change a thing. > > Did you try tcp? Yep. Same thing. /S -- Sławek Żak / UNIX Systems Administrator _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-database To unsubscribe, send any mail to "[email protected]"