Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres is using 100% CPU

Postgres is using 100% CPU

From
Ashik S L
Date:
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.

Thanks,
Ashik

Re: Postgres is using 100% CPU

From
Tomas Vondra
Date:
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

Re: Postgres is using 100% CPU

From
Tomas Vondra
Date:
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