Re: Performance monitoring

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance monitoring
Date: 2007-05-14 11:12:49
Message-ID: 46484431.1070307@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Heikki Linnakangas napsal(a):
> Jim C. Nasby wrote:

>
> There is two counters for checkpoints in pgstats, the number of timed
> (triggered by checkpoint_timeout) and requested (triggered by
> checkpoint_segments) checkpoints.
>
> Maybe we should improve the stats system so that we can collect events
> with timestamps and durations, but in my experience log files actually
> are the most reliable and universal way to collect real-time performance
> information. Any serious tool has a generic log parser. The other
> alternative is SNMP. I welcome the efforts on pgsnmpd..

Whats about add some DTrace probes?

Zdenek

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-05-14 11:41:45 Re: Seq scans roadmap
Previous Message Hannu Krosing 2007-05-14 10:57:32 Re: plperl vs. bytea

Browse pgsql-patches by date

  From Date Subject
Next Message Gregory Stark 2007-05-14 11:36:14 Re: [PATCHES] OS/X startup scripts
Previous Message Heikki Linnakangas 2007-05-14 09:52:45 Re: [PATCHES] OS/X startup scripts