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
[-- Attachment #1 --] Claus Guttesen wrote: > Ubuntu 7.10: > > 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.) > > FreeBSD 7.0 stable as of Jan. 28'th: > > grep "transactions:" sysbench-clients-24|sort > transactions: 10001 (1600.36 per sec.) > transactions: 10002 (1963.95 per sec.) > transactions: 10005 (1973.17 per sec.) > > 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 helped by patching postgresql to remove setproctitle(). Other than that, from the sysbench line I see this is OLTP benchmark which should mean 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 here. [-- Attachment #2 --] -----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fnl35p$hnj$1>