Re: A guide/tutorial to performance monitoring and tuning

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Nikhil G(dot) Daddikar" <ngd(at)celoxis(dot)com>
Subject: Re: A guide/tutorial to performance monitoring and tuning
Date: 2008-06-30 13:54:08
Message-ID: 200806301554.14683.cedric.villemain@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Le Friday 27 June 2008, Scott Marlowe a écrit :
> On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <ngd(at)celoxis(dot)com> wrote:
> > 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?
>
> If you run nagios, lookup the pgsql nagios plugin. it's quite an
> impressive little bit of code.

http://bucardo.org/check_postgres/ but it only supervise afaik

you can collect data and monitor with munin :
http://pgfoundry.org/projects/muninpgplugins/

--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Schuller 2008-06-30 14:59:03 VACUUM ANALYZE blocking both reads and writes to a table
Previous Message Jonah H. Harris 2008-06-30 13:34:27 Re: Federated Postgresql architecture ?