From owner-freebsd-performance@FreeBSD.ORG Thu Jan 31 20:16:30 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 A2FDF16A41A for ; Thu, 31 Jan 2008 20:16:30 +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 2F98D13C478 for ; Thu, 31 Jan 2008 20:16:29 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JKfph-0006Vw-GH for freebsd-performance@freebsd.org; Thu, 31 Jan 2008 20:16:25 +0000 Received: from 78-1-69-12.adsl.net.t-com.hr ([78.1.69.12]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 31 Jan 2008 20:16:25 +0000 Received: from ivoras by 78-1-69-12.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 31 Jan 2008 20:16:25 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Thu, 31 Jan 2008 21:16:18 +0100 Lines: 43 Message-ID: References: <479E3C5E.1070405@FreeBSD.org> <47A043FD.9090607@FreeBSD.org> <47A0CD11.802@FreeBSD.org> <9bbcef730801301157n25684018y3d43bfdd0301a8dd@mail.gmail.com> <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig658431FD5296B48F8B5B4F38" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 78-1-69-12.adsl.net.t-com.hr User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) In-Reply-To: <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> 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: Thu, 31 Jan 2008 20:16:30 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig658431FD5296B48F8B5B4F38 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Niki Denev wrote: > HZ=3D1000 > Time: > 239 seconds total > 122 seconds of transactions (4 per second) > What do you think? This is a very low result :) I don't know your machine or the parameters = you used with postmark but even FreeBSD on two striped 7.5 kRPM drives=20 can achieve ~~ 110 tps (so ~~ 50 for a single drive). In the same=20 circumstances and with the right file system - reiserfs in this case -=20 Linux can achieve close to 900 tps (170 tps with ext3). This is the kind = of difference I am talking about. A change of 4 tps to 6 tps is not=20 generally useful. --------------enig658431FD5296B48F8B5B4F38 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 iD8DBQFHoiySldnAQVacBcgRAtGHAKDKx7r8o2ahpEFlYpkkpyPGnhKorgCgtq9A JJU4b0DO9R6LB5z3yEdpwCU= =JJd6 -----END PGP SIGNATURE----- --------------enig658431FD5296B48F8B5B4F38--