Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2FB31650F4D for ; Mon, 30 Jun 2008 11:06:50 -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 01199-08 for ; Mon, 30 Jun 2008 11:06:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id 66276650FCD for ; Mon, 30 Jun 2008 10:54:30 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id 081AC578076; Mon, 30 Jun 2008 15:54:26 +0200 (CEST) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RiU3PSFyYBEX; Mon, 30 Jun 2008 15:54:25 +0200 (CEST) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id D976A578074; Mon, 30 Jun 2008 15:54:25 +0200 (CEST) Received: from [192.168.0.12] (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by pyrrha.dalibo.net (Postfix) with ESMTP id 1C700578074; Mon, 30 Jun 2008 15:54:23 +0200 (CEST) From: =?iso-8859-1?q?C=E9dric_Villemain?= Organization: dalibo.com To: pgsql-performance@postgresql.org Subject: Re: A guide/tutorial to performance monitoring and tuning Date: Mon, 30 Jun 2008 15:54:08 +0200 User-Agent: KMail/1.9.9 Cc: "Scott Marlowe" , "Nikhil G. Daddikar" References: <4864F7C7.3020901@celoxis.com> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1763941.b21Niljxqf"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200806301554.14683.cedric.villemain@dalibo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/235 X-Sequence-Number: 30585 --nextPart1763941.b21Niljxqf Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le Friday 27 June 2008, Scott Marlowe a =E9crit=A0: > On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar wro= te: > > 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 :=20 http://pgfoundry.org/projects/muninpgplugins/ =2D-=20 C=E9dric Villemain Administrateur de Base de Donn=E9es Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org --nextPart1763941.b21Niljxqf Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkho5YEACgkQo/dppWjpEvzEtwCeKgtCL5RKBz23mbnT3Vosexpu ccEAnRNqqFFVp8/gT4C9ZfJFba0IwCiX =MyIq -----END PGP SIGNATURE----- --nextPart1763941.b21Niljxqf--