Re: high user cpu, massive SELECTs, no io waiting problem

From: marcin mank <marcin(dot)mank(at)gmail(dot)com>
To: Thomas Pöhler <tp(at)turtle-entertainment(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org, Felix Feinhals <ff(at)turtle-entertainment(dot)de>, Verteiler_A-Team <a-team(at)turtle-entertainment(dot)de>, Björn Metzdorf <bm(at)turtle-entertainment(dot)de>
Subject: Re: high user cpu, massive SELECTs, no io waiting problem
Date: 2011-02-15 19:55:48
Message-ID: AANLkTi=2qyQCavQZgKpbGnwyv75P9jD9J+D5mSE_s8x+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Feb 15, 2011 at 6:19 PM, Thomas Pöhler
<tp(at)turtle-entertainment(dot)de> wrote:
> Hi list,
>
> See ganglia: http://dl.dropbox.com/u/183323/CPUloadprobsdb1.jpg
>

What is the bottom graph? queries/minute? Looks like Your database is
just getting hammered.
Maybe there is a really badly coded page somewhere (a query for each
user or something similar)?

Greetings
Marcin Mańk

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Marti Raudsepp 2011-02-15 21:13:50 Re: LIMIT on partitioned-table!?
Previous Message Kim A. Brandt 2011-02-15 19:33:27 Re: LIMIT on partitioned-table!?