pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postmaster eating up all my cpu
2+ messages / 2 participants
[nested] [flat]

* Postmaster eating up all my cpu
@ 2015-05-28 11:25  birimblongas <bianca.stephani@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: birimblongas @ 2015-05-28 11:25 UTC (permalink / raw)
  To: pgsql-performance

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?



--
View this message in context: http://postgresql.nabble.com/Postmaster-eating-up-all-my-cpu-tp5851428.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postmaster eating up all my cpu
@ 2015-05-30 20:45  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  parent: birimblongas <bianca.stephani@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tomas Vondra @ 2015-05-30 20:45 UTC (permalink / raw)
  To: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2015-05-30 20:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-05-28 11:25 Postmaster eating up all my cpu birimblongas <bianca.stephani@gmail.com>
2015-05-30 20:45 ` Tomas Vondra <tomas.vondra@2ndquadrant.com>

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