Re: hyperthreaded cpu still an issue in 8.4?

Поиск
Список
Период
Сортировка
От Dave Youatt
Тема Re: hyperthreaded cpu still an issue in 8.4?
Дата
Msg-id 4A6F4688.6070000@meteorsolutions.com
обсуждение исходный текст
Ответ на hyperthreaded cpu still an issue in 8.4?  (Doug Hunley <doug@hunley.homeip.net>)
Ответы Re: hyperthreaded cpu still an issue in 8.4?  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance

On Mon, 27 Jul 2009, Dave Youatt wrote:

Greg, those are compelling numbers for the new Nehalem processors.
Great news for postgresql. Do you think it's due to the new internal
interconnect...

Unlikely. Different threads on the same CPU core share their resources, so
they don't need an explicit communication channel at all (I'm simplifying massively here). A real interconnect is only needed between CPUs and between different cores on a CPU, and of course to the outside world. Scott's explanation of why SMT works better now is much more likely to be the real reason.

:-) there's also this interconnect thingie between sockets, cores and memory. Nehalem has a new one (for Intel), integrated memory controller, that is.  And a new on-chip cache organization.

 I'm still betting on the interconnect(s), particularly for bandwidth-intensive, data pumping server apps.  And it looks like the other new interconnect ("QuickPath") plays well w/the integrated memory controller for multi-socket systems.

Greg, in your spare time...  Also, curious how Nehalem compares w/AMD Phenom II, esp the newer ones w/multi-lane(?) HT

And apologies to the list for straying off topic a bit.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Nikolas Everett
Дата:
Сообщение: Re: Will Postgres ever lock with read only queries?
Следующее
От: Greg Smith
Дата:
Сообщение: Re: hyperthreaded cpu still an issue in 8.4?