From: | Nikola Ivanov <xlpizza(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | Nik <XLPizza(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres using 100% CPU |
Date: | 2006-02-15 19:33:29 |
Message-ID: | 66182b050602151133s671e380fnf9ec8e6a5a936d8b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <mmoncure(at)gmail(dot)com> wrote:
>
> n 14 Feb 2006 06:46:48 -0800, Nik <XLPizza(at)gmail(dot)com> 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%), 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?
>
> something is seriously wrong. Fire up the task manager and determine
> the pid of the process that is sucking cpu. Then query
> pg_stat_activity to determine who/what is doing it (you will have to
> restore stats). consider setting statement logging to get the exact
> offender.
>
> Merlin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-02-15 20:08:41 | Re: I see this as the end of BDB in MySQL without a |
Previous Message | Michael Crozier | 2006-02-15 19:04:55 | Re: Date last vacuum |