Re: Postgres is using 100% CPU

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres is using 100% CPU
Date: 2015-05-29 17:17:29
Message-ID: 55689F29.3060104@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2015-05-29 17:18:22 Re: Postgres is using 100% CPU
Previous Message Ashik S L 2015-05-29 16:40:35 Postgres is using 100% CPU

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2015-05-29 17:18:22 Re: Postgres is using 100% CPU
Previous Message Ashik S L 2015-05-29 16:40:35 Postgres is using 100% CPU