Re: CPU Pegged Very High

From: "Carlo Florendo" <fcarlo(at)ntsp(dot)nec(dot)co(dot)jp>
To: "Hunter Hillegas" <lists(at)lastonepicked(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: CPU Pegged Very High
Date: 2002-03-07 04:42:10
Message-ID: 019101c1c592$7407a640$213b1cac@perseus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


From: "Hunter Hillegas" <lists(at)lastonepicked(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2002-03-07 05:43:35 Installing 7.2 on RedHat 7.1
Previous Message Tom Lane 2002-03-07 04:38:38 Re: joins?