Message-ID: <556A2179.3030809@2ndquadrant.com>
Date: Sat, 30 May 2015 22:45:45 +0200
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Postmaster eating up all my cpu
References: <1432812350946-5851428.post@n5.nabble.com>
In-Reply-To: <1432812350946-5851428.post@n5.nabble.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi,

On 05/28/15 13:25, birimblongas wrote:
> Hi,
>
> My app was working just fine. A month ago postmaster started to eat all my
> cpu sometimes (not all day, but a lot of times and everyday) and then my app
> gets really slow and sometimes don't even complete the requests.
>
> What could it be?

A lot of things. The first step should be looking at pg_stat_activity, 
what is the process eating the CPU doing.

We also need much more information about your system - what PostgreSQL 
version are you using, what kind of OS, configuration etc.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance