From: | mike g <mike(at)thegodshalls(dot)com> |
---|---|
To: | Werner vd Merwe <werner(at)saicom(dot)co(dot)za> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Profiling |
Date: | 2004-07-24 03:21:02 |
Message-ID: | 1090639261.11436.1.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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!
>
>
>
> I posted this question in NOVICE some time ago, but have not really
> had any replies.
>
>
>
> We are running a PG7.4 database, being accessed through jsps called
> 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.
>
>
>
> The current hardware config is as follows:
>
>
>
> Dual Xeon 2.4GHz CPUs
>
> 3 GB RAM
>
> 3 X WD 73 GB drives in RAID-5
>
>
>
> 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.
>
>
>
> Hope the question makes sense.
>
>
>
> Best regards and thank you in advance.
>
> Werner vd Merwe
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | mike g | 2004-07-24 03:23:23 | Re: Backup |
Previous Message | bcscomputers | 2004-07-23 17:02:53 |