Re: High SYS CPU - need advise - Mailing list pgsql-general

From John R Pierce
Subject Re: High SYS CPU - need advise
Date
Msg-id 50A41652.3020509@hogranch.com
Whole thread Raw
In response to Re: High SYS CPU - need advise  (Vlad <marchenko@gmail.com>)
Responses Re: High SYS CPU - need advise  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Dmitriy Tyugaev
Date:
Subject: FATAL: index contains unexpected zero page at block
Next
From: Tianyin Xu
Date:
Subject: Re: How do query optimizers affect window functions