Re: Postgres is using 100% CPU - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: Postgres is using 100% CPU
Date
Msg-id 55689F29.3060104@2ndquadrant.com
Whole thread Raw
In response to Postgres is using 100% CPU  (Ashik S L <ashiksl178@gmail.com>)
List pgsql-bugs
Hi,

On 05/29/15 18:40, Ashik S L wrote:
> Hi All,
>
> I am using postgresDB on redhat machine which is having 4GB RAM
> machine. As soon as it starts to update the postgres DB it will reach
> 100%cpu. It will comedown to normal after 40 minutes. I tried perform
> some tuning on the postgres DB, But result was same.I am not postgres
> DB expert. Even we are not seeing in all machine. Only few machines we
> are seeing this issue. Any help on this would be appreciated.

We need to know more about what you mean by "update the postgres DB",
and basic information like database size, PostgreSQL version etc.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Ashik S L
Date:
Subject: Postgres is using 100% CPU
Next
From: Tomas Vondra
Date:
Subject: Re: Postgres is using 100% CPU