From: Grega Bremec <grega.bremec@noviforum.si>
To: Eduardo Almeida <edalmeida@yahoo.com>
Cc: Jan Wieck <JanWieck@yahoo.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-advocacy@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks
Date: Thu, 22 Apr 2004 15:42:49 +0200
Message-ID: <20040422134249.GA14342@elbereth.noviforum.si> (raw)
In-Reply-To: <20040422125318.26053.qmail@web60601.mail.yahoo.com>
References: <4086CDC7.5000204@Yahoo.com>
<20040422125318.26053.qmail@web60601.mail.yahoo.com>
...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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: grega.bremec@noviforum.si, edalmeida@yahoo.com, JanWieck@yahoo.com, josh@agliodbs.com, pgsql-advocacy@postgresql.org
Subject: Re: [PERFORM] MySQL vs PG TPC-H benchmarks
In-Reply-To: <20040422134249.GA14342@elbereth.noviforum.si>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox