From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: pgsql-bugs@postgresql.org
Subject: Re: Postgres is using 100% CPU
Date: Fri, 29 May 2015 19:18:22 +0200
Message-ID: <55689F5E.8020808@2ndquadrant.com> (raw)
In-Reply-To: <CAC=-3DfaqG0OguwRaUP1AzS-hY4=v9RCjZoiqbWtvGHAR43ecQ@mail.gmail.com>
References: <CAC=-3DfaqG0OguwRaUP1AzS-hY4=v9RCjZoiqbWtvGHAR43ecQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tomas.vondra@2ndquadrant.com, pgsql-bugs@postgresql.org
Subject: Re: Postgres is using 100% CPU
In-Reply-To: <55689F5E.8020808@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox