Thread: 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 >