Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 086359FBEDD
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 11 Jul 2007 13:59:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 03660-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 11 Jul 2007 13:59:10 -0300 (ADT)
X-Greylist: delayed 00:21:38.412122 by SQLgrey-1.7.5
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id D56DC9FBF77
	for <pgsql-performance@postgresql.org>;
	Wed, 11 Jul 2007 13:59:11 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from esmeralda.bireme.br (esmeralda.bireme.br [200.6.42.225])
	by svr4.postgresql.org (Postfix) with ESMTP id 877245AF8BF
	for <pgsql-performance@postgresql.org>;
	Wed, 11 Jul 2007 16:37:30 +0000 (GMT)
Received: from localhost (unknown [127.0.0.1])
	by esmeralda.bireme.br (Postfix) with ESMTP id 42CB8FDB8;
	Wed, 11 Jul 2007 16:37:23 +0000 (UTC)
Received: from esmeralda.bireme.br ([127.0.0.1])
	by localhost (esmeralda.bireme.br [127.0.0.1]) (amavisd-new, port 10024)
	with SMTP id 29492-04; Wed, 11 Jul 2007 13:37:22 -0300 (BRT)
Received: by esmeralda.bireme.br (Postfix, from userid 502)
	id 92038FDDD; Wed, 11 Jul 2007 13:37:22 -0300 (BRT)
Received: from [127.0.0.1] (unknown [172.27.0.33])
	by esmeralda.bireme.br (Postfix) with ESMTP id CD058FDB8;
	Wed, 11 Jul 2007 13:37:19 -0300 (BRT)
Message-ID: <46950747.4080508@bireme.org>
Date: Wed, 11 Jul 2007 13:37:27 -0300
From: =?UTF-8?B?QW5kcsOpIEdvbWVzIExhbWFzIE90ZXJv?= <andre.otero@bireme.org>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: Philippe Amelant <pamelant@companeo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL publishes first real benchmark
References: <20070709155954.1B20F78D85@fx8.security-mail.net>
	<1184163398.16023.103.camel@phil.companeo.local>
In-Reply-To: <1184163398.16023.103.camel@phil.companeo.local>
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: amavisd-new at bireme.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.273 tagged_above=0 required=5 tests=BAYES_40=-0.185,
	HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.457
X-Spam-Level: *
X-Archive-Number: 200707/103
X-Sequence-Number: 25787

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"=
>
  <title></title>
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
I don't this so, because DB2 is running on a Sun Sparc T1 processor
(<a class=3D"moz-txt-link-freetext" href=3D"http://www.sun.com/processors=
/UltraSPARC-T1/">http://www.sun.com/processors/UltraSPARC-T1/</a>) 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=3D"moz-smiley-s1"><span> :-) </span></span><br>
<br>
<br>
Best Regards,<br>
Andr=C3=A9<br>
<br>
Philippe Amelant escreveu:
<blockquote cite=3D"mid1184163398.16023.103.camel@phil.companeo.local"
 type=3D"cite">
  <pre wrap=3D"">am I wrong or DB2 9.1 is faster on less powerfull hardwa=
re ?

Le lundi 09 juillet 2007 =C3=A0 11:57 -0400, Jignesh K. Shah a =C3=A9crit=
 :
  </pre>
  <blockquote type=3D"cite">
    <pre wrap=3D"">Hello all,

I think this result will be useful for performance discussions of=20
postgresql against other databases.

<a class=3D"moz-txt-link-freetext" href=3D"http://www.spec.org/jAppServer=
2004/results/res2007q3/">http://www.spec.org/jAppServer2004/results/res20=
07q3/</a>

More on Josh Berkus's blog:

<a class=3D"moz-txt-link-freetext" href=3D"http://blogs.ittoolbox.com/dat=
abase/soup/archives/postgresql-publishes-first-real-benchmark-17470">http=
://blogs.ittoolbox.com/database/soup/archives/postgresql-publishes-first-=
real-benchmark-17470</a>

Regards,
Jignesh


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
    </pre>
  </blockquote>
  <pre wrap=3D""><!---->
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                <a class=3D"moz-txt-link-freetext" href=3D"http://www.pos=
tgresql.org/about/donate">http://www.postgresql.org/about/donate</a>

  </pre>
</blockquote>
</body>
</html>