X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 96153D1B1C7 for ; Sat, 24 Jul 2004 00:24:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54491-03 for ; Sat, 24 Jul 2004 03:24:08 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id A08C0D1B184 for ; Sat, 24 Jul 2004 00:24:02 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (sccrmhc12) with ESMTP id <20040724032405012009cmq6e>; Sat, 24 Jul 2004 03:24:07 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6O3L31N011467; Fri, 23 Jul 2004 22:21:03 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6O3L2VD011464; Fri, 23 Jul 2004 22:21:02 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: Profiling From: mike g Reply-To: mike@thegodshalls.com To: Werner vd Merwe Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset= Content-Transfer-Encoding: quoted-printable Message-Id: <1090639261.11436.1.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Fri, 23 Jul 2004 22:21:02 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/277 X-Sequence-Number: 14345 There are but it depends if you are running under Solaris, Linux etc. Most of the below can be checked with applications included with your OS. Mike On Fri, 2004-07-23 at 06:23, Werner vd Merwe wrote: > Good day all! >=20 >=20=20 >=20 > I posted this question in NOVICE some time ago, but have not really > had any replies. >=20 >=20=20 >=20 > We are running a PG7.4 database, being accessed through jsp=E2=80=99s cal= led > through Tomcat. The problem is, that sometimes the database comes to a > complete standstill, sometimes because of deadlocks, but I would > venture to say that most times it is because it runs out of resources. >=20 >=20=20 >=20 > The current hardware config is as follows: >=20 >=20=20 >=20 > Dual Xeon 2.4GHz CPU=E2=80=99s >=20 > 3 GB RAM >=20 > 3 X WD 73 GB drives in RAID-5 >=20 >=20=20 >=20 > My question is, are there any software or apps out there that can > monitor CPU, memory and shared buffer usage etc so I can have a > pro-active way of monitoring when we need to upgrade hardware, or just > tweak the software. I am aware that running complex queries will take > a large chunk of CPU time, but it would be good for me to have the > normal running load of PG. >=20 >=20=20 >=20 > Hope the question makes sense. >=20 >=20=20 >=20 > Best regards and thank you in advance. >=20 > Werner vd Merwe >=20 >=20