Date: Sun, 29 Jun 2008 14:59:39 -0400 (EDT)
From: Greg Smith <gsmith@gregsmith.com>
To: "Nikhil G. Daddikar" <ngd@celoxis.com>
cc: pgsql-performance@postgresql.org
Subject: Re: A guide/tutorial to performance monitoring and tuning
In-Reply-To: <4864F7C7.3020901@celoxis.com>
Message-ID: <Pine.GSO.4.64.0806291451340.12045@westnet.com>
References: <4864F7C7.3020901@celoxis.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Fri, 27 Jun 2008, Nikhil G. Daddikar wrote:

> 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".

That's because it does depend.  I collect up the best of resources out 
there and keep track of them at 
http://wiki.postgresql.org/wiki/Performance_Optimization so if you didn't 
find that yet there's probably some good ones you missed.

Right now I'm working with a few other people to put together a more 
straightforward single intro guide that should address some of the 
vagueness you point out here, but that's still a few weeks away from being 
ready.

Monitoring performance isn't really covered in any of this though.  Right 
now the best simple solution out there is probably Nagios with the 
PostgreSQL plug-in.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD