I found the pid of the postgres process that was consuming all the CPU. I turned the stats back on (and reloaded the conf file), but when I query pg_stat_activity I get nothing back. No records.
On 2/15/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECT
> 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
On 2/15/06, Nikola Ivanov <[EMAIL PROTECTED]> wrote:
> I found the pid of the postgres process that was consuming all the CPU. I
> turned the stats back on (and reloaded the conf file), but when I query
> pg_stat_activity I get nothing back. No records.
did you restart server? I think stats colle
n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECTED]> wrote:
> 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%), wh
Nik wrote:
> I noticed that CPU utilization on the server is 100% for past few
100% CPU usage is not a problem. When the number of waiting processes
goes up, then you have a reason to start being concerned.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
