Re: Sampling Profler for Postgres

On Mon, 2009-03-09 at 21:57 -0400, Tom Lane wrote:
> ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> > For resource-based profilers, we have DTrace probes[1] and continue to
> > extend them[2], but unfortunately DTrace only works on Solaris and limited
> > platforms.
>
> FWIW, the systemtap guys are really, really close to having a working
> DTrace equivalent for Linux:
> http://gnu.wildebeest.org/diary/2009/02/24/systemtap-09-markers-everywhere/
>
> It's not *quite* there for our purposes
> https://bugzilla.redhat.com/show_bug.cgi?id=488941
> but I'll be surprised if I'm not dtracing on my Fedora 10 machine before
> the week is out.

After all this time, you think it will be done in a week :-)

> I'm not at all convinced that we should be putting effort into a
> homegrown, partial substitute for DTrace.

I was, but I'm not anymore.

Do you think we will be able to enable this in builds for 8.4?

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support