pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBarcelona vs Tigerton
6+ messages / 6 participants
[nested] [flat]
* Barcelona vs Tigerton
@ 2007-09-11 07:57 Mindaugas <ml@kilimas.com>
0 siblings, 4 replies; 6+ messages in thread
From: Mindaugas @ 2007-09-11 07:57 UTC (permalink / raw)
To: pgsql-performance
Hello,
Now that both 4x4 out it's time for us to decide which one should be better for our PostgreSQL and Oracle. And especially for Oracle we really need such server to squeeze everything from Oracle licenses. Both of the databases handle OLTP type of the load.
Since we plan to buy 4U HP DL580 or 585 and only very few of them so power ratings are not very critical in this our case.
First benchmarks (http://www.anandtech.com/IT/showdoc.aspx?i=3091) show that Intel still has more raw CPU power but Barcelona scales much better and also has better memory bandwidth which I believe is quite critical with 16 cores and DB usage pattern.
On the other hand Intel's X7350 (2.93GHz) has almost 50% advantage in CPU frequency against 2GHz Barcelona.
Regards,
Mindaugas
P.S. tweakers.net does not have both of those yet? Test results far away? :)
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Barcelona vs Tigerton
@ 2007-09-11 08:31 Luke Lonergan <LLonergan@greenplum.com>
parent: Mindaugas <ml@kilimas.com>
3 siblings, 0 replies; 6+ messages in thread
From: Luke Lonergan @ 2007-09-11 08:31 UTC (permalink / raw)
To: Mindaugas <ml@kilimas.com>; pgsql-performance
Mindaugas,
The Anandtech results appear to me to support a 2.5 GHz Barcelona
performing better than the available Intel CPUs overall.
If you can wait for the 2.5 GHz AMD parts to come out, they'd be a
better bet IMO especially considering 4 sockets. In fact, have you seen
quad QC Intel benchmarks?
BTW - Can someone please get Anand a decent PG benchmark kit? :-)
At least we can count on excellent PG bench results from the folks at
Tweakers.
- Luke
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Mindaugas
> Sent: Tuesday, September 11, 2007 12:58 AM
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] Barcelona vs Tigerton
>
> Hello,
>
> Now that both 4x4 out it's time for us to decide which one
> should be better for our PostgreSQL and Oracle. And
> especially for Oracle we really need such server to squeeze
> everything from Oracle licenses. Both of the databases handle
> OLTP type of the load.
> Since we plan to buy 4U HP DL580 or 585 and only very few
> of them so power ratings are not very critical in this our case.
>
> First benchmarks
> (http://www.anandtech.com/IT/showdoc.aspx?i=3091) show that
> Intel still has more raw CPU power but Barcelona scales much
> better and also has better memory bandwidth which I believe
> is quite critical with 16 cores and DB usage pattern.
> On the other hand Intel's X7350 (2.93GHz) has almost 50%
> advantage in CPU frequency against 2GHz Barcelona.
>
> Regards,
>
> Mindaugas
>
> P.S. tweakers.net does not have both of those yet? Test
> results far away? :)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Barcelona vs Tigerton
@ 2007-09-11 15:11 Greg Smith <gsmith@gregsmith.com>
parent: Mindaugas <ml@kilimas.com>
3 siblings, 0 replies; 6+ messages in thread
From: Greg Smith @ 2007-09-11 15:11 UTC (permalink / raw)
To: pgsql-performance
On Tue, 11 Sep 2007, Mindaugas wrote:
> Now that both 4x4 out it's time for us to decide which one should be
> better for our PostgreSQL and Oracle.
You're going to have to wait a bit for that. No one has had both to
compare for long enough yet to reach a strong conclusion, and you're
probably going to need a database-specific benchmark before there's useful
data for your case. Yesterday's meta-coverage at Ars was a nice summary
of the current state of things:
http://arstechnica.com/news.ars/post/20070910-barcelonas-out-and-the-reviews-are-out.html
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Barcelona vs Tigerton
@ 2007-09-11 19:52 Guy Rouillier <guyr-ml1@burntmail.com>
parent: Mindaugas <ml@kilimas.com>
3 siblings, 1 reply; 6+ messages in thread
From: Guy Rouillier @ 2007-09-11 19:52 UTC (permalink / raw)
To: pgsql-performance
Mindaugas wrote:
> Hello,
>
> Now that both 4x4 out it's time for us to decide which one should be better for our PostgreSQL and Oracle. And especially for Oracle we really need such server to squeeze everything from Oracle licenses. Both of the databases handle OLTP type of the load.
> Since we plan to buy 4U HP DL580 or 585 and only very few of them so power ratings are not very critical in this our case.
>
> First benchmarks (http://www.anandtech.com/IT/showdoc.aspx?i=3091) show that Intel still has more raw CPU power but Barcelona scales much better and also has better memory bandwidth which I believe is quite critical with 16 cores and DB usage pattern.
> On the other hand Intel's X7350 (2.93GHz) has almost 50% advantage in CPU frequency against 2GHz Barcelona.
Barcelona was just announced yesterday. I wouldn't want to be betting
my business on it just yet. Plus, AMD usually is able to up the clock on
their chips pretty well after they've got a few production runs under
their belts. If you've absolutely got to have something today, I'd say
Intel would be a safer bet. If you can afford to wait 3-4 months, then
you'll benefit from some industry experience as well as production
maturity with Barcelona, and can judge then which better fits your needs.
--
Guy Rouillier
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Barcelona vs Tigerton
@ 2007-09-11 19:59 Joshua D. Drake <jd@commandprompt.com>
parent: Guy Rouillier <guyr-ml1@burntmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Joshua D. Drake @ 2007-09-11 19:59 UTC (permalink / raw)
To: Guy Rouillier <guyr-ml1@burntmail.com>; +Cc: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Guy Rouillier wrote:
> Mindaugas wrote:
>> Hello,
> Barcelona was just announced yesterday. I wouldn't want to be betting
> my business on it just yet. Plus, AMD usually is able to up the clock on
> their chips pretty well after they've got a few production runs under
> their belts. If you've absolutely got to have something today, I'd say
> Intel would be a safer bet. If you can afford to wait 3-4 months, then
> you'll benefit from some industry experience as well as production
> maturity with Barcelona, and can judge then which better fits your needs.
>
AMD has already stated they will be ramping up the MHZ toward the end of
the year. Patience is a virtue.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG5vO3ATb/zqfZUUQRAkv5AJ9vEF/OnM23X30YdWVIiY2xGtDrHACfZ678
fYfZxD7XdIH+VYYzhGSz9w4=
=eBTJ
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Barcelona vs Tigerton
@ 2007-09-11 23:00 Decibel! <decibel@decibel.org>
parent: Mindaugas <ml@kilimas.com>
3 siblings, 0 replies; 6+ messages in thread
From: Decibel! @ 2007-09-11 23:00 UTC (permalink / raw)
To: Mindaugas <ml@kilimas.com>; +Cc: pgsql-performance
On Tue, Sep 11, 2007 at 10:57:43AM +0300, Mindaugas wrote:
> Hello,
>
> Now that both 4x4 out it's time for us to decide which one should be better for our PostgreSQL and Oracle. And especially for Oracle we really need such server to squeeze everything from Oracle licenses. Both of the databases handle OLTP type of the load.
You might take a look at replacing Oracle with EnterpriseDB... but I'm a
bit biased. ;)
> Since we plan to buy 4U HP DL580 or 585 and only very few of them so power ratings are not very critical in this our case.
>
> First benchmarks (http://www.anandtech.com/IT/showdoc.aspx?i=3091) show that Intel still has more raw CPU power but Barcelona scales much better and also has better memory bandwidth which I believe is quite critical with 16 cores and DB usage pattern.
> On the other hand Intel's X7350 (2.93GHz) has almost 50% advantage in CPU frequency against 2GHz Barcelona.
Databases are all about bandwidth and latency. Compute horsepower almost
never matters.
The only reason I'd look at the clock rate is if it substantially
affects memory IO capability; but from what I've seen, memory seems to
be fairly independent of CPU frequency now-a-days, so I don't think
there's a huge difference there.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-09-11 23:00 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-11 07:57 Barcelona vs Tigerton Mindaugas <ml@kilimas.com>
2007-09-11 08:31 ` Luke Lonergan <LLonergan@greenplum.com>
2007-09-11 15:11 ` Greg Smith <gsmith@gregsmith.com>
2007-09-11 19:52 ` Guy Rouillier <guyr-ml1@burntmail.com>
2007-09-11 19:59 ` Joshua D. Drake <jd@commandprompt.com>
2007-09-11 23:00 ` Decibel! <decibel@decibel.org>
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