Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] MySQL vs PG TPC-H benchmarks

From: Eduardo Almeida <edalmeida(at)yahoo(dot)com>
To: Grega Bremec <grega(dot)bremec(at)noviforum(dot)si>
Cc: Jan Wieck <JanWieck(at)yahoo(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>,pgsql-advocacy(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks
Date: 2004-04-22 13:59:10
Message-ID: 20040422135910.24475.qmail@web60607.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
Grega,

Thats 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 <grega(dot)bremec(at)noviforum(dot)si> 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

In response to

Responses

pgsql-performance by date

Next:From: Michiel MeeuwissenDate: 2004-04-22 14:40:23
Subject: Re: order by index, and inheritance
Previous:From: Rod TaylorDate: 2004-04-22 13:46:48
Subject: Re: order by index, and inheritance

pgsql-advocacy by date

Next:From: Tom LaneDate: 2004-04-22 15:54:48
Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks
Previous:From: Grega BremecDate: 2004-04-22 13:42:49
Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group