X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3C1D2D1BACD; Thu, 22 Apr 2004 10:42:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56629-02; Thu, 22 Apr 2004 10:42:55 -0300 (ADT) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by svr1.postgresql.org (Postfix) with ESMTP id 5A783D1B579; Thu, 22 Apr 2004 10:42:50 -0300 (ADT) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i3MDgnHh014369; Thu, 22 Apr 2004 15:42:49 +0200 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i3MDgn2C014368; Thu, 22 Apr 2004 15:42:49 +0200 Date: Thu, 22 Apr 2004 15:42:49 +0200 From: Grega Bremec To: Eduardo Almeida Cc: Jan Wieck , Josh Berkus , pgsql-advocacy@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks Message-ID: <20040422134249.GA14342@elbereth.noviforum.si> References: <4086CDC7.5000204@Yahoo.com> <20040422125318.26053.qmail@web60601.mail.yahoo.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="xHFwDpU9dbj6ez1V" Content-Disposition: inline In-Reply-To: <20040422125318.26053.qmail@web60601.mail.yahoo.com> User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/206 X-Sequence-Number: 4178 --xHFwDpU9dbj6ez1V Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Thu, Apr 22, 2004 at 05:53:18AM -0700, Eduardo Almeida used the k= eyboard: >=20 > - The configuration of the machine is: > Dual opteron 64 bits model 240 > 4GB RAM > 960 GB on RAID 0 > Mandrake Linux 64 with Kernel 2.6.5 (I compiled a > kernel for this test) > Java SDK java version "1.4.2_04" > PostgreSQL JDBC pg74.1jdbc3.jar >=20 > - The TPC-H configuration is: > TPC-H 2.0.0 > 100GB > load using flat files > Refresh functions using java >=20 I'll just add for the reference, to those that aren't aware of it, the Java virtual machine for x86_64 only exists in the 1.5 branch so far, and it's so utterly unstable that most every notable shuffling around in the memory crashes it. :) Hence the 1.4.2_04 is a 32-bit application running in 32-bit mode. I won't be getting into how much this affects the benchmarks as I didn't really get into how CPU- and memory-intensive the refresh functions are in these, so as I said - let's keep it a reference. Cheers, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --xHFwDpU9dbj6ez1V Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAh8vZDo/EMYD4+osRAtE8AJ9p6blMEGRKc8wHc9ti+YcKBwk/+QCfaswM TvcECDmUWoW4yiuQX1WNhoY= =F8Wo -----END PGP SIGNATURE----- --xHFwDpU9dbj6ez1V--