Thread: Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
From
"Mohan, Ross"
Date:
Adam -
Is compiling postmaster with profiling support just a flag
in the build/make? Or is there something more involved?
I'd like to be able to do this in the future and so am
curious about means/methods.
If this is a RTFM, just let me know that (am currently
Reading The F Manual), but if you have any "special sauce"
here, that'd be of great interest.
Thanks
-Ross
-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Adam Palmblad
Sent: Wednesday, April 06, 2005 7:23 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Tweaking a C Function I wrote
I wanted to see if I could squeeze any more performance out of a C set
returning function I wrote. As such, I looked to a profiler. Is it
possible to get profile information on the function I wrote? I've got
postmaster and my function compiled with profiling support, and can find
the gmon.out files... can I actually look at the call tree that occurs
when my function is being executed or will I be limited to viewing calls
to functions in the postmaster binary?
-Adam
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Re: Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
From
Tom Lane
Date:
"Mohan, Ross" <RMohan@arbinet.com> writes:
> Is compiling postmaster with profiling support just a flag
> in the build/make? Or is there something more involved?
cd .../src/backend
make PROFILE="-pg -DLINUX_PROFILE" all
reinstall binary
You don't need -DLINUX_PROFILE if not on Linux, of course.
regards, tom lane
The recompile was done by the sysadmin, but I believe the flags are -pg -DLINUX_PROFILING for profiling, and -g for debug symbols. This leaves gmon.out files around, which you can then do a "gprof /usr/bin/postmaster gmon.out" to see whats going on. My problem is that this gives me data on what functions are being called with respect to the postmaster binary, but I don't know which of my functions - in my shared library - in my C procedure are taking the most time. -Adam Mohan, Ross wrote: >Adam - > >Is compiling postmaster with profiling support just a flag >in the build/make? Or is there something more involved? > >I'd like to be able to do this in the future and so am >curious about means/methods. > >If this is a RTFM, just let me know that (am currently >Reading The F Manual), but if you have any "special sauce" >here, that'd be of great interest. > >Thanks > >-Ross > >-----Original Message----- >From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Adam Palmblad >Sent: Wednesday, April 06, 2005 7:23 PM >To: pgsql-performance@postgresql.org >Subject: [PERFORM] Tweaking a C Function I wrote > > >I wanted to see if I could squeeze any more performance out of a C set >returning function I wrote. As such, I looked to a profiler. Is it >possible to get profile information on the function I wrote? I've got >postmaster and my function compiled with profiling support, and can find >the gmon.out files... can I actually look at the call tree that occurs >when my function is being executed or will I be limited to viewing calls >to functions in the postmaster binary? > >-Adam > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > > >