Re: profiling on win32

Thanks for posting this Merlin. Bruce, perhaps this should be added to
"Compiling PostgreSQL On Native Win32 FAQ" for reference?

Regards, Dave.

> -----Original Message-----
> From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf
> Of Merlin Moncure
> Sent: 25 August 2005 21:36
> To: pgsql-hackers-win32(at)postgresql(dot)org
> Subject: Re: [pgsql-hackers-win32] profiling on win32
>
> Finally got profiling going on windows. Just a little FYI for other
> win32 developers/users who might be interested. gprof is probably the
> easiest way to do it. gprof is the gnu profiler which is built into
> gcc.
>
> Some quick observations:
>
> 1. no timings, just function call counts were output until I
> upgraded to
> mingw 4.1 current
>
> 2. make sure you use mingw provided gprof, not cygwin etc. Make sure
> gprof version matches gcc version.
>
> 3. syntax to get profile graph is
> gprof postgres.exe gmon.out
> this actually tripped me up for a bit due to confusing error message
> from gprof.
>
> 4. to compile postgresql for profiling (assumes you already
> have mingw,
> etc. installed).
> a. do make clean, make, and make install as normal.
> b. edit makefile.global and add -pg to the end of cflags line.
> c. do make clean, and make, and make install of just the backend. you
> can do this by running make from backend folder.
>
> 5. profile file (gmon.out) is dumped into database folder when
> postgresql is run as a service.
>
> That's it! I'm sure the unix people are thinking, 'duh!' but
> it took me
> a bit of effort to get profiling going so I'd thought I'd pass the
> information along.
>
> Merlin
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>