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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-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

Browse pgsql-advocacy by date

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

Browse pgsql-performance by date

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