Date: Fri, 13 Jan 2006 13:28:28 -0800 From: Brooks Davis <brooks@one-eyed-alien.net> To: Arne Woerner <arne_woerner@yahoo.com> Cc: freebsd-database@freebsd.org, Slawek Zak <slawek.zak@gmail.com>, freebsd-performance@freebsd.org Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <20060113212828.GB1819@odin.ac.hmc.edu> In-Reply-To: <20060113211048.31785.qmail@web30313.mail.mud.yahoo.com> References: <787bbe1c0601131220j7b3a052ege5fe4683156312a7@mail.gmail.com> <20060113211048.31785.qmail@web30313.mail.mud.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--mYCpIKhGyMATD0i+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 13, 2006 at 01:10:48PM -0800, Arne Woerner wrote: > Hiho! >=20 > --- Slawek Zak <slawek.zak@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. > > > I would like to suggest some tests (I do not have a clear idea, > why your system becomes slower; a hypothesis will follow below): >=20 > 1. benchmark the local disc (watch cpu usage via e. g. vmstat 1) > % dd if=3D/dev/zero of=3D/some/local/filesystem/a bs=3D1m count=3D1000 >=20 > 2. benchmark the NFS filesystem (watch cpu usage via e. g. vmstat > 1) > % dd if=3D/dev/zero of=3D/some/NFS/filesystem/a bs=3D1m count=3D1000 I'd suggest also testing with small blocks as well. I suspect that a large portion of many database accesses quite small and thus transaction overhead, not streaming performance is likely to be the issue. If streaming performance is an issue, increasing your network's MTU should help somewhat. > 3. test the NIC performance with (again watching the CPU usage > might help) > % ping -s 50000 <nfs-server> > I get 17Mbit/sec which is the actual rate... > neo# ping -s 50000 vaako > PING vaako.riddick.homeunix.org (10.1.1.3): 50000 data bytes > 50008 bytes from 10.1.1.3: icmp_seq=3D0 ttl=3D64 time=3D46.584 ms I don't think this tells you much if anything. You need to know what your protocol overhead is, not how many ICMP packets you can spew. > My theory would be, that your NICs need a lot of CPU time, while > your local discs dont need so much CPU time. :-) That's certainly part of it, but I doubt it's the whole story. -- Brooks --=20 Any statement of the form "X is the one, true Y" is FALSE. PGP fingerprint 655D 519C 26A7 82E7 2529 9BF0 5D8E 8BE9 F238 1AD4 --mYCpIKhGyMATD0i+ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFDyBt2XY6L6fI4GtQRAgrwAJsF1m5v/11V7w4LAFLXikEOgchpUQCfWoTe uzFjzaJ2sYtFyoQOcq4Hkg0= =xJXN -----END PGP SIGNATURE----- --mYCpIKhGyMATD0i+--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060113212828.GB1819>