Re: Barcelona vs Tigerton
От | Decibel! |
---|---|
Тема | Re: Barcelona vs Tigerton |
Дата | |
Msg-id | 20070911230022.GH38801@decibel.org обсуждение исходный текст |
Ответ на | Barcelona vs Tigerton ("Mindaugas" <ml@kilimas.com>) |
Список | 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 especiallyfor Oracle we really need such server to squeeze everything from Oracle licenses. Both of the databases handleOLTP 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 ourcase. > > First benchmarks (http://www.anandtech.com/IT/showdoc.aspx?i=3091) show that Intel still has more raw CPU power but Barcelonascales much better and also has better memory bandwidth which I believe is quite critical with 16 cores and DB usagepattern. > 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)
Вложения
В списке pgsql-performance по дате отправления: