Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group