Postgres Pro
Downloads
Home   >   mailing lists

Re: high user cpu, massive SELECTs, no io waiting problem - Mailing list pgsql-performance

From marcin mank
Subject Re: high user cpu, massive SELECTs, no io waiting problem
Date
Msg-id AANLkTi=2qyQCavQZgKpbGnwyv75P9jD9J+D5mSE_s8x+@mail.gmail.com
Whole thread Raw
In response to high user cpu, massive SELECTs, no io waiting problem  (Thomas Pöhler <tp@turtle-entertainment.de>)
List pgsql-performance
Tree view 
On Tue, Feb 15, 2011 at 6:19 PM, Thomas Pöhler
<tp@turtle-entertainment.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

pgsql-performance by date:

Previous
From: "Kim A. Brandt"
Date:
Subject: Re: LIMIT on partitioned-table!?
Next
From: Marti Raudsepp
Date:
Subject: Re: LIMIT on partitioned-table!?