From: André Gomes Lamas Otero <andre.otero@bireme.org>
To: Philippe Amelant <pamelant@companeo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL publishes first real benchmark
Date: Wed, 11 Jul 2007 13:37:27 -0300
Message-ID: <46950747.4080508@bireme.org> (raw)
In-Reply-To: <1184163398.16023.103.camel@phil.companeo.local>
References: <20070709155954.1B20F78D85@fx8.security-mail.net>
<1184163398.16023.103.camel@phil.companeo.local>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
I don't this so, because DB2 is running on a Sun Sparc T1 processor
(<a class="moz-txt-link-freetext" href="http://www.sun.com/processors/UltraSPARC-T1/">http://www.sun.com/processors/UltraSPARC-T1/<...;) that's implements much
more features, like thread level parelelism, than AMD Opteron.<br>
<br>
the DB2 installation:<br>
<br>
<pre>J2EE AppServer HW (SUT hardware)
Hardware Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire T2000 Server
Processor: Sun UltraSPARC T1
MHz: 1400
# of CPUs: 8 cores, 1 chip, 8 cores/chip (4 threads/core)
Memory (MB): 65536
L1 Cache: 16KB(I)+8KB(D) per core
L2 Cache: 3MB per chip</pre>
the postgres installation:<br>
<pre>J2EE AppServer HW (SUT hardware)
Hardware Vendor: Sun Microsystems, Inc.
Model Name: Sun Fire X4200 M2
Processor: AMD Opteron 2220 SE
MHz: 2800
# of CPUs: 4 cores, 2 chips, 2 cores/chip
Memory (MB): 8192
L1 Cache: 64KB(I)+16KB(D) per core
L2 Cache: 1MB per core</pre>
<br>
postgres with a inferior hardware has better performance than DB2 <span
class="moz-smiley-s1"><span> :-) </span></span><br>
<br>
<br>
Best Regards,<br>
André<br>
<br>
Philippe Amelant escreveu:
<blockquote cite="mid1184163398.16023.103.camel@phil.companeo.local"
type="cite">
<pre wrap="">am I wrong or DB2 9.1 is faster on less powerfull hardware ?
Le lundi 09 juillet 2007 à 11:57 -0400, Jignesh K. Shah a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Hello all,
I think this result will be useful for performance discussions of
postgresql against other databases.
<a class="moz-txt-link-freetext" href="http://www.spec.org/jAppServer2004/results/res2007q3/">http://www.spec.org/jAppServer2004/res...;
More on Josh Berkus's blog:
<a class="moz-txt-link-freetext" href="http://blogs.ittoolbox.com/database/soup/archives/postgresql-publishes-first-real-benchmark-17470...;
Regards,
Jignesh
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
</pre>
</blockquote>
<pre wrap=""><!---->
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/about/donate">http://www.postgresql.org/about/donate</a;
</pre>
</blockquote>
</body>
</html>
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: andre.otero@bireme.org, pamelant@companeo.com
Subject: Re: PostgreSQL publishes first real benchmark
In-Reply-To: <46950747.4080508@bireme.org>
* 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