Re: Profiling PostgreSQL - Mailing list pgsql-performance

From Tom Lane
Subject Re: Profiling PostgreSQL
Date
Msg-id 3712.1400766532@sss.pgh.pa.us
Whole thread Raw
In response to Profiling PostgreSQL  (Dimitris Karampinas <dkarampin@gmail.com>)
Responses Re: Profiling PostgreSQL  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-performance
Dimitris Karampinas <dkarampin@gmail.com> writes:
> Is there any way to get the call stack of a function when profiling
> PostgreSQL with perf ?
> I configured with --enable-debug, I run a benchmark against the system and
> I'm able to identify a bottleneck.
> 40% of the time is spent on an spinlock yet I cannot find out the codepath
> that gets me there.
> Using --call-graph with perf record didn't seem to help.

Call graph data usually isn't trustworthy unless you built the program
with -fno-omit-frame-pointer ...

            regards, tom lane


pgsql-performance by date:

Previous
From: David Boreham
Date:
Subject: Re: Profiling PostgreSQL
Next
From: Michael Paquier
Date:
Subject: Re: Profiling PostgreSQL