Date: Thu, 31 Jan 2008 21:16:18 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <fntaaj$dp8$1@ger.gmane.org> In-Reply-To: <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <b41c75520801281221i5fbb32f3p1e2f3be40a8dfa74@mail.gmail.com> <479E3C5E.1070405@FreeBSD.org> <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com> <fnmrri$pi4$1@ger.gmane.org> <b41c75520801290146g4e6e2c17oe2fc432245253ba7@mail.gmail.com> <47A043FD.9090607@FreeBSD.org> <fnpjvo$n8i$1@ger.gmane.org> <47A0CD11.802@FreeBSD.org> <9bbcef730801301157n25684018y3d43bfdd0301a8dd@mail.gmail.com> <2e77fc10801310826v2fabb5g594840241784fc7@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) --------------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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fntaaj$dp8$1>