Postgres Pro
Downloads
Home   >   mailing lists

Re: 60 core performance with 9.3 - Mailing list pgsql-performance

From Andres Freund
Subject Re: 60 core performance with 9.3
Date
Msg-id 20140627091951.GA16680@awork2.anarazel.de
Whole thread Raw
In response to Re: 60 core performance with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: 60 core performance with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Re: 60 core performance with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: "songtebo"
Date:
Subject: Can improve 'limit 1' ? with slow function
Next
From: Mark Kirkwood
Date:
Subject: Re: 60 core performance with 9.3