Re: Additional DTrace Probes

Hi,

Robert Lor <Robert.Lor@Sun.COM> wrote:

> The attached patch contains the probes (originally came from Theo 
> Schlossnagle) that were removed from the previous submitted patch. 
> Zdenek had some concerns  about the way the probes were implemented  
> http://archives.postgresql.org/pgsql-hackers/2008-07/msg01168.php. If 
> there are specific recommendations, I'd be more than happy to make the 
> changes and get them resubmitted.

This will introduce SLRU and Executor probes.
We already have Lock, LWLock, Buffer, I/O and XLogs probes.

I'd like to have the following probes, too. In my experience,
they could be bottlenecks or consume much time in some situations.
   - idle in transaction   - spinlock wait-and-retry   - CPU: Trigger execution   - CPU: Encoding conversion   -
Network:send() and recv()   - smgr: lseek() calls   - Tempfile reads and writes
 

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center