Date: Sat, 14 Jan 2006 13:52:07 +0100 From: Slawek Zak <slawek.zak@gmail.com> To: Claus Guttesen <kometen@gmail.com> Cc: freebsd-database@freebsd.org, freebsd-performance@freebsd.org Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <787bbe1c0601140452p43291399xe79e99fd1e956e4a@mail.gmail.com> In-Reply-To: <b41c75520601131415u36e2006es@mail.gmail.com> References: <787bbe1c0601131220j7b3a052ege5fe4683156312a7@mail.gmail.com> <b41c75520601131415u36e2006es@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 1/13/06, Claus Guttesen <kometen@gmail.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?787bbe1c0601140452p43291399xe79e99fd1e956e4a>