Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 29E369FB63B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 20 Mar 2007 22:27:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 09533-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 20 Mar 2007 22:27:09 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from crestone.coronasolutions.com (crestone.coronasolutions.com
	[66.45.104.24]) by postgresql.org (Postfix) with ESMTP id E6FBA9FB635
	for <pgsql-performance@postgresql.org>;
	Tue, 20 Mar 2007 22:27:14 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by crestone.coronasolutions.com (Postfix) with ESMTP id CC7FB6446BD;
	Tue, 20 Mar 2007 19:27:13 -0600 (MDT)
Received: from crestone.coronasolutions.com ([127.0.0.1])
	by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 14848-01; Tue, 20 Mar 2007 19:27:13 -0600 (MDT)
Received: from mac.local (c-67-166-27-159.hsd1.co.comcast.net [67.166.27.159])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by crestone.coronasolutions.com (Postfix) with ESMTP id E60FD6446BC
	for <pgsql-performance@postgresql.org>;
	Tue, 20 Mar 2007 19:27:12 -0600 (MDT)
Message-ID: <460089F0.9060806@drivefaster.net>
Date: Tue, 20 Mar 2007 19:27:12 -0600
From: Dan Harris <fbsd@drivefaster.net>
User-Agent: Thunderbird 2.0b2 (Macintosh/20070116)
MIME-Version: 1.0
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Determining server load from client
References: <460080A2.20800@drivefaster.net>
In-Reply-To: <460080A2.20800@drivefaster.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at coronasolutions.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL, BAYES_40,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200703/294
X-Sequence-Number: 23699

Dan Harris wrote:
> I've found that it would be helpful to be able to tell how busy my 
> dedicated PG server is ( Linux 2.6 kernel, v8.0.3 currently ) before 
> pounding it with some OLAP-type queries. 
..snip

Thank you all for your great ideas!  I'm going to try the perl function 
as that seems like a very elegant way of doing it.

-Dan