Postgres Professional
en

Re: Whence the Opterons?

От: William Yu
Тема: Re: Whence the Opterons?
Дата: ,
Msg-id: d5o6ar$1nuv$1@news.hub.org
(см: обсуждение, исходный текст)
Ответ на: Re: Whence the Opterons?  ("Anjan Dave")
Список: pgsql-performance

Скрыть дерево обсуждения

Whence the Opterons?  (Mischa Sandberg, )
 Re: Whence the Opterons?  (Ian Meyer, )
 Re: Whence the Opterons?  (Steve Poe, )
  Re: Whence the Opterons?  ("Gavin M. Roy", )
 Re: Whence the Opterons?  (Andrew Sullivan, )
  Re: Whence the Opterons?  (Josh Berkus, )
   Re: Whence the Opterons?  (Andrew Sullivan, )
 Re: Whence the Opterons?  (Sam Vilain, )
  Re: Whence the Opterons?  (Mischa Sandberg, )
 Re: Whence the Opterons?  (Geoffrey, )
  Re: Whence the Opterons?  (John A Meinel, )
   Re: Whence the Opterons?  (Geoffrey, )
 Re: Whence the Opterons?  ("Anjan Dave", )
  Re: Whence the Opterons?  (John A Meinel, )
 Re: Whence the Opterons?  ("Anjan Dave", )
  Re: Whence the Opterons?  (John A Meinel, )
   Re: Whence the Opterons?  (Jeff Frost, )
  Re: Whence the Opterons?  (William Yu, )
 Re: Whence the Opterons?  ("Anjan Dave", )
  Re: Whence the Opterons?  (Andrew Rawnsley, )
 Re: Whence the Opterons?  ("Magnus Hagander", )
 Re: Whence the Opterons?  (Richard Rowell, )
 Re: Whence the Opterons?  ("Mohan, Ross", ) 
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%.

В списке pgsql-performance по дате сообщения:

Предыдущее:
От: David Roussel
Дата:
Сообщение: Re: "Hash index" vs. "b-tree index" (PostgreSQL 8.0)
Следующее:
От: Neil Conway
Дата:
Сообщение: Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL