Обсуждение: Postgres is using 100% CPU
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
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
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