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
Show quoted text
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