Re: High SYS CPU - need advise

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: High SYS CPU - need advise
Дата
Msg-id 50A41652.3020509@hogranch.com
обсуждение исходный текст
Ответ на Re: High SYS CPU - need advise  (Vlad <marchenko@gmail.com>)
Ответы Re: High SYS CPU - need advise  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
On 11/14/12 1:34 PM, Vlad wrote:
> thanks for your feedback. While implementing connection pooling would
> make resources utilization more efficient, I don't think it's the root
> of my problem. Most of the connected clients are at IDLE. When I do
>
> select * from pg_stat_activity where current_query not like '%IDLE%';
>
> I only see several active queries at any given time.

what about during these spikes?

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitriy Tyugaev
Дата:
Сообщение: FATAL: index contains unexpected zero page at block
Следующее
От: Tianyin Xu
Дата:
Сообщение: Re: How do query optimizers affect window functions