From: | Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Whence the Opterons? |
Date: | 2005-05-10 03:03:23 |
Message-ID: | B46F5120-DC27-49B9-AFC7-0B05152E421A@ravensfield.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Iron Systems has a fair selection of opteron machines, up to 4 way.
The one I have has Tyan guts.
On May 9, 2005, at 4:10 PM, Anjan Dave wrote:
> The DP+DC isn't available yet, from Sun. Only QP+DC is, for which the
> bid opens at 38k, that is a bit pricey -:)
>
>
> -----Original Message-----
> From: William Yu [mailto:wyu(at)talisys(dot)com]
> Sent: Monday, May 09, 2005 1:24 PM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] Whence the Opterons?
>
> Unfortunately, Anandtech only used Postgres just a single time in his
> benchmarks. And what it did show back then was a huge performance
> advantage for the Opteron architecture over Xeon in this case.
> Where the
>
> fastest Opterons were just 15% faster in MySQL/MSSQL/DB2 than the
> fastest Xeons, it was 100%+ faster in Postgres. He probably got rid of
> Postgres from his benchmark suite since it favors Opteron too much.
> As a
>
> general hardware review site, makes senses that he needs to get more
> neutral apps in order to get free systems to review and (ahem) ad
> dollars.
>
> That being said, I wouldn't get a quad Opteron system anyways now that
> the dual core Opterons are available. A DP+DC system would be
> faster and
>
> cheaper than a pure quad system. Unless of course, I needed a QP+DC
> for
> 8-way SMP.
>
>
>
>
>
>
> Anjan Dave wrote:
>
>> Wasn't the context switching issue occurring in specific cases only?
>>
>> I haven't seen any benchmarks for a 50% performance difference.
>>
> Neither
>
>> have I seen any benchmarks of pure disk IO performance of specific
>> models of Dell vs HP or Sun Opterons.
>>
>> Thanks,
>> Anjan
>>
>>
>>> EMC you can file an RPQ via your sales contacts to get it approved,
>>> though not sure how lengthy/painful that process might be, or if
>>> it's
>>> gonna be worth it.
>>>
>>> Read the article devoted to the v40z on anandtech.com.
>>>
>>> I am also trying to get a quad-Opteron versus the latest quad-XEON
>>>
>>
>> from
>>
>>
>>> Dell (6850), but it's hard to justify a difference between a 15K
>>> dell
>>> versus a 30k v40z for a 5-8% performance gain (read the XEON Vs.
>>>
>>
>> Opteron
>>
>>
>>> Database comparo on anandtech.com)
>>>
>>> Thanks,
>>> Anjan
>>>
>>>
>>
>>
>> 15k vs 30k is indeed a big difference. But also realize that Postgres
>> has a specific benefit to Opterons versus Xeons. The context
>> switching
>> storm happens less on an Opteron for some reason.
>>
>> I would venture a much greater benefit than 5-8%, more like 10-50%.
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-05-10 04:10:57 | Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL |
Previous Message | Bruce Momjian | 2005-05-10 02:20:45 | Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL |