Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 740ED650F60
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 27 Jun 2008 11:48:12 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 68156-04-6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 27 Jun 2008 11:47:50 -0300 (ADT)
X-Greylist: delayed 00:23:43.436375 by SQLgrey-1.7.6
Received: from ozone.celoxis.com (mail.celoxis.com [75.125.91.2])
	by postgresql.org (Postfix) with ESMTP id 942BC650F2D
	for <pgsql-performance@postgresql.org>;
	Fri, 27 Jun 2008 11:46:57 -0300 (ADT)
Received: from [192.168.0.106] ([117.195.32.174]) (authenticated bits=0)
	by ozone.celoxis.com (8.13.8/8.13.8) with ESMTP id m5REObLR032373
	for <pgsql-performance@postgresql.org>; Fri, 27 Jun 2008 10:24:38 -0400
Message-ID: <4864F7C7.3020901@celoxis.com>
Date: Fri, 27 Jun 2008 19:53:03 +0530
From: "Nikhil G. Daddikar" <ngd@celoxis.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: A guide/tutorial to performance monitoring and tuning
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200806/198
X-Sequence-Number: 30548

Hello,

I have been searching on the net on how to tune and monitor performance 
of my postgresql server but not met with success. A lot of information 
is vague and most often then not the answer is "it depends". Can anyone 
of you refer me a nice guide or tutorial on this?

Thanks.