From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 17:25:33 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id AE06216A417 for ; Mon, 28 Jan 2008 17:25:33 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 35FB213C442 for ; Mon, 28 Jan 2008 17:25:32 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JJXja-0006Ff-1I for freebsd-performance@freebsd.org; Mon, 28 Jan 2008 17:25:26 +0000 Received: from 89-172-47-154.adsl.net.t-com.hr ([89.172.47.154]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 28 Jan 2008 17:25:26 +0000 Received: from ivoras by 89-172-47-154.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 28 Jan 2008 17:25:26 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Mon, 28 Jan 2008 18:25:13 +0100 Lines: 51 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigDE192207C6F41BC1F0AD8AE2" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 89-172-47-154.adsl.net.t-com.hr User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) In-Reply-To: X-Enigmail-Version: 0.95.6 Sender: news Subject: Re: postgresql-performance using sysbench X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 Jan 2008 17:25:33 -0000 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--