Skip site navigation (1) Skip section navigation (2)

Generic Monitoring Framework with DTrace patch

From: Robert Lor <Robert(dot)Lor(at)Sun(dot)COM>
To: pgsql-patches(at)postgresql(dot)org
Subject: Generic Monitoring Framework with DTrace patch
Date: 2006-07-21 07:40:53
Message-ID: (view raw or whole thread)
Lists: pgsql-hackerspgsql-patches

I've have attached a patch along with two new files.This patch should 
reflect what we discussed at the Summit. Please let me know if I miss 

There are a few potential/known issues which I need help from the gurus.

1) The current logic in src/backend/Makefile will only work for Solaris 
versions with DTrace, and Peter has offered to help fix this one.

2) Currently an environment variable called DTRACE_DATA_MODEL is used in 
src/backend/Makefile to tell the dtrace command whether to generate a 32 
or 64 bit binary.  This may not be a reliable approach since a user can 
forget to set this variable. Perhaps adding a flag like DTRACEFLAGS to 
the configure script is a better approach. Thoughts?

3)  When using --enable-depend, "gmake clean" removes all *.d files, 
including the DTrace probe definition file which also has a .d 
extension.  I tried to to use a different extension but the dtrace tool 
didn't like that. Since we only plan to have one probe definition file 
(pgsqlprobes.d) and one provider called "postgresql", I think 
src/ can be changed to not remove this file. Is this 
acceptable or is there a better solution?

I have created several DTrace scripts and uploaded them to

Many thanks to Gavin and Tom for their help with creating and inserting 
the current set of probes, and Peter for his help with the config files.


Attachment: gmf_dtrace.patch
Description: text/x-patch (9.1 KB)
Attachment: pgsqlprobes.d
Description: text/plain (395 bytes)
Attachment: pg_trace.h
Description: text/x-chdr (1.2 KB)


pgsql-hackers by date

Next:From: Robert LorDate: 2006-07-21 07:56:56
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Previous:From: moisesDate: 2006-07-21 07:38:41
Subject: Transaction Speed and real time database

pgsql-patches by date

Next:From: Dave PageDate: 2006-07-21 09:39:56
Subject: BF Failure on Bandicoot
Previous:From: Tom LaneDate: 2006-07-21 03:22:40
Subject: Re: [PATCHES] modular

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group