Date: Tue, 17 Apr 2007 15:21:20 -0400 From: Kris Kennaway <kris@obsecurity.org> To: Kevin Way <kevin@insidesystems.net> Cc: freebsd-performance@freebsd.org, Robert Watson <rwatson@FreeBSD.org> Subject: Re: Anyone interested in improving postgresql scaling? Message-ID: <20070417192120.GA5191@xor.obsecurity.org> In-Reply-To: <4625174B.5090208@insidesystems.net> References: <461B0CD0.8090404@insidesystems.net> <20070417174825.X42234@fledge.watson.org> <4625174B.5090208@insidesystems.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--G4iJoqBmSsgzjUCe Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Apr 17, 2007 at 02:51:55PM -0400, Kevin Way wrote: > I built 7.0 as of 6 days ago, and ran the same test using 8-cores, ULE=20 > and 4BSD. The results are available at: >=20 > http://blog.insidesystems.net/articles/2007/04/11/postgresql-scaling-on-6= -2-and-7-0 >=20 > Unfortunately, I can't run the additional tests, as the machines in=20 > question have now been deployed to production. I should have similar=20 > equipment available in a few weeks, and will try the other tests at that= =20 > point. That's better but still not comparable to my results. One important change you may have missed was to enable MALLOC_PRODUCTION in /usr/src/lib/libc/stdlib/malloc.c. This disables malloc debugging which may have significant overhead. My results from about a month ago: http://people.freebsd.org/~kris/scaling/nickel.png The big dip between 5-7 clients is believed to be due to a ULE bug that has known cause but is not yet fixed (on dual core CPUs processes are bouncing around between the two cores too much). The main point is that apart from this anomaly in the middle there is approximately linear scaling from 1 to 8 CPUs. On your system it is not scaling linearly beyond 4. I do have some other changes in my kernel but I don't think any of them are enough to explain this difference. Anyway, get back to us when you can retest with the above change. Kris --G4iJoqBmSsgzjUCe Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD4DBQFGJR4wWry0BWjoQKURAq7JAJiPX4ogSZlSl+hTCqAUCLW5zt5TAJ9m28/C ZXwUu7WIgVoXmNrPt8iilA== =c4Xu -----END PGP SIGNATURE----- --G4iJoqBmSsgzjUCe--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070417192120.GA5191>