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 574A6D1E12B for ; Thu, 22 Apr 2004 10:59:09 -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 65063-03 for ; Thu, 22 Apr 2004 10:59:11 -0300 (ADT) Received: from web60607.mail.yahoo.com (web60607.mail.yahoo.com [216.109.118.245]) by svr1.postgresql.org (Postfix) with SMTP id F004DD1DC74 for ; Thu, 22 Apr 2004 10:59:06 -0300 (ADT) Message-ID: <20040422135910.24475.qmail@web60607.mail.yahoo.com> Received: from [200.17.210.82] by web60607.mail.yahoo.com via HTTP; Thu, 22 Apr 2004 06:59:10 PDT Date: Thu, 22 Apr 2004 06:59:10 -0700 (PDT) From: Eduardo Almeida Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks To: Grega Bremec Cc: Jan Wieck , Josh Berkus , pgsql-advocacy@postgresql.org, pgsql-performance@postgresql.org In-Reply-To: <20040422134249.GA14342@elbereth.noviforum.si> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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/210 X-Sequence-Number: 4182 Grega, Thatīs why I used java 32bits and needed to compile the kernel 2.6.5 with the 32bits modules. To reference, Sun has java 64bits just to IA64 and Solaris Sparc 64 not to Opteron. regards, Eduardo --- Grega Bremec wrote: > ...and on Thu, Apr 22, 2004 at 05:53:18AM -0700, > Eduardo Almeida used the keyboard: > > > > - 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 > > > > - The TPC-H configuration is: > > TPC-H 2.0.0 > > 100GB > > load using flat files > > Refresh functions using java > > > > 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, > -- > Grega Bremec > Senior Administrator > Noviforum Ltd., Software & Media > http://www.noviforum.si/ > > ATTACHMENT part 2 application/pgp-signature __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25Ē http://photos.yahoo.com/ph/print_splash