Re: 60 core performance with 9.3

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: 60 core performance with 9.3
Дата
Msg-id 20140627091951.GA16680@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: 60 core performance with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: 60 core performance with 9.3
Re: 60 core performance with 9.3
Список pgsql-performance
On 2014-06-27 14:28:20 +1200, Mark Kirkwood wrote:
> My feeling is spinlock or similar, 'perf top' shows
>
> kernel find_busiest_group
> kernel _raw_spin_lock
>
> as the top time users.

Those don't tell that much by themselves, could you do a hierarchical
profile? I.e. perf record -ga? That'll at least give the callers for
kernel level stuff. For more information compile postgres with
-fno-omit-frame-pointer.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: "songtebo"
Дата:
Сообщение: Can improve 'limit 1' ? with slow function
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: 60 core performance with 9.3