Skip site navigation (1) Skip section navigation (2)

Postgres using 100% CPU

From: "Nik" <XLPizza(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres using 100% CPU
Date: 2006-02-14 14:46:48
Message-ID: 1139928408.281298.232690@g44g2000cwa.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
I have a fairly large (about 30Gb) PostgreSQL 8.1 database running on
Windows 2003 Server.
I noticed that CPU utilization on the server is 100% for past few days,
and postgres process is taking up most of that CPU (95%-100%). There is
only one connection to the database at the time and that one is not
doing any queries.

I turned off stats collector, and any row stat collectors, and I
increased the number of check points since I have been getting the
error about check point switches being to frequent. Postgres now uses a
bit less CPU (60-90%), which is still a lot considering that no
processing is being done. Is there anything else I can do to lower this
CPU utilization? Is there a way I can pinpoint exactly what part of
postgres is using this CPU?

Thanks.


Responses

pgsql-general by date

Next:From: Sebastjan TrepcaDate: 2006-02-14 15:13:03
Subject: Time complexity of statements
Previous:From: Michael FuhrDate: 2006-02-14 05:38:49
Subject: Re: Limiting with a left outer join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group