Обсуждение: CPU Pegged Very High

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?

FYI, 7.2, built from source, running on Red Hat 7.1.

Thanks,
Hunter

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
>