Re: CPU Pegged Very High - Mailing list pgsql-general

From Carlo Florendo
Subject Re: CPU Pegged Very High
Date
Msg-id 019101c1c592$7407a640$213b1cac@perseus
Whole thread Raw
In response to CPU Pegged Very High  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
From: "Hunter Hillegas" <lists@lastonepicked.com>

> I access a PostgreSQL database via JDBC. Since moving to 7.2, I've seen
> Postgres eating a lot of CPU time. Any idea how I could go about looking
> into this? To see if Postgres is just crunching more queries or of
something
> else is going wrong?

Are you sure it's not the JDBC that's having problems?  Have you tried to do
a "top" and see
cpu/mem resources?

best regards.

Carlo Florendo




>
> FYI, 7.2, built from source, running on Red Hat 7.1.
>
> Thanks,
> Hunter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: joins?
Next
From: Benjamin Smith
Date:
Subject: Back-porting a database?