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

Поиск
Список
Период
Сортировка
От marcin mank
Тема Re: high user cpu, massive SELECTs, no io waiting problem
Дата
Msg-id AANLkTi=2qyQCavQZgKpbGnwyv75P9jD9J+D5mSE_s8x+@mail.gmail.com
обсуждение исходный текст
Ответ на high user cpu, massive SELECTs, no io waiting problem  (Thomas Pöhler <tp@turtle-entertainment.de>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: "Kim A. Brandt"
Дата:
Сообщение: Re: LIMIT on partitioned-table!?
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: LIMIT on partitioned-table!?