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
Date: Sun, 29 Jun 2008 14:59:39 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0806291451340.12045@westnet.com> (raw)
In-Reply-To: <4864F7C7.3020901@celoxis.com>
References: <4864F7C7.3020901@celoxis.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, ngd@celoxis.com
Subject: Re: A guide/tutorial to performance monitoring and tuning
In-Reply-To: <Pine.GSO.4.64.0806291451340.12045@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox