Date: Mon, 14 May 2007 13:12:49 +0200
From: Zdenek Kotala <Zdenek.Kotala@Sun.COM>
Subject: Re: Performance monitoring
In-reply-to: <4646B61C.1010103@enterprisedb.com>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: "Jim C. Nasby" <decibel@decibel.org>, Greg Smith <gsmith@gregsmith.com>,
	pgsql-hackers@postgresql.org
Message-id: <46484431.1070307@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <Pine.GSO.4.64.0704010051050.14920@westnet.com>
	<200704030814.33999.peter_e@gmx.net>
	<Pine.GSO.4.64.0704030927180.5732@westnet.com>
	<46443F02.6060300@enterprisedb.com>
	<Pine.GSO.4.64.0705111009080.18685@westnet.com>
	<46448DC8.4050102@enterprisedb.com> <20070512211948.GA58786@nasby.net>
	<4646B61C.1010103@enterprisedb.com>
User-Agent: Thunderbird 2.0b2 (X11/20070227)

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