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:18:22
Message-ID: 55689F5E.8020808@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

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.

... also, this is not a bug. This is clearly a performance question, so
please post it to pgsql-performance list.

--
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 Ashik S L 2015-05-29 17:57:18 Fwd: Postgres is using 100% CPU
Previous Message Tomas Vondra 2015-05-29 17:17:29 Re: Postgres is using 100% CPU

Browse pgsql-performance by date

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