From: Adam Palmblad <adam@aers.ca>
To: Mohan, Ross <RMohan@arbinet.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Building postmaster with Profiling Support WAS "Tweaking a C
Date: Mon, 07 Mar 2005 14:26:04 -0800
Message-ID: <422CD4FC.6080007@aers.ca> (raw)
In-Reply-To: <CC74E7E10A8A054798B6611BD1FEF4D30625DA3B@vamail01.thexchange.com>
References: <CC74E7E10A8A054798B6611BD1FEF4D30625DA3B@vamail01.thexchange.com>
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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adam@aers.ca, RMohan@arbinet.com
Subject: Re: Building postmaster with Profiling Support WAS "Tweaking a C
In-Reply-To: <422CD4FC.6080007@aers.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox