Date: Mon, 28 Jan 2008 18:25:13 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <fnl35p$hnj$1@ger.gmane.org> In-Reply-To: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigDE192207C6F41BC1F0AD8AE2 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Claus Guttesen wrote: > Ubuntu 7.10: >=20 > grep "transactions:" sysbench-clients-24|sort > transactions: 10000 (2354.49 per sec.) > transactions: 10001 (2126.28 per sec.) > transactions: 10001 (2215.52 per sec.) > transactions: 10001 (2236.03 per sec.) >=20 > FreeBSD 7.0 stable as of Jan. 28'th: >=20 > grep "transactions:" sysbench-clients-24|sort > transactions: 10001 (1600.36 per sec.) > transactions: 10002 (1963.95 per sec.) > transactions: 10005 (1973.17 per sec.) >=20 > In other runs FreeBSD also seems to trail Ubuntu. Are there any knobs > I could try on FreeBSD? I think the excellent results Kris got with FreeBSD were significantly=20 helped by patching postgresql to remove setproctitle(). Other than that, = from the sysbench line I see this is OLTP benchmark which should mean=20 a lot of write transactions, and I've consistently seen much better file = system write performance on Linux than on FreeBSD. No tuning can help her= e. --------------enigDE192207C6F41BC1F0AD8AE2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHng/5ldnAQVacBcgRAmSxAKDJMMxOowRxmfBd1wM4vavU2As2XACglmdd xBUMPGxWnmOWIxVcjNKkYaY= =RY6+ -----END PGP SIGNATURE----- --------------enigDE192207C6F41BC1F0AD8AE2--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fnl35p$hnj$1>