Re: Postgres is using 100% CPU

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Postgres is using 100% CPU
Дата
Msg-id 55689F29.3060104@2ndquadrant.com
обсуждение исходный текст
Ответ на Postgres is using 100% CPU  (Ashik S L <ashiksl178@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ashik S L
Дата:
Сообщение: Postgres is using 100% CPU
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Postgres is using 100% CPU