Re: High SYS CPU - need advise

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: High SYS CPU - need advise
Date: 2012-11-14 22:08:18
Message-ID: 50A41652.3020509@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tianyin Xu 2012-11-14 22:16:29 Re: How do query optimizers affect window functions
Previous Message Vlad 2012-11-14 21:34:15 Re: High SYS CPU - need advise