| From: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
|---|---|
| To: | bing1221 <bzhao(at)recognia(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High CPU usage buy low I/O wait |
| Date: | 2013-04-18 20:54:08 |
| Message-ID: | 20130418205408.GI32580@aart.rice.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Apr 11, 2013 at 04:30:54PM -0700, bing1221 wrote:
> Our server is running postgresql 8.4.15. During day time the cpu usage always
> around 80%, but it's not IO bound. The swap space is looking OK also. Also
> we setup pgbadger and enable all logs to monitor the slow query but they all
> finished quick. Usually it has 60 incoming connections, and we have
> pgbouncer to control the pool. Any suggestions I can look into it? Thank
> you.
Why do you think you have a problem? It sounds like normal system usage.
Regards,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitalii Tymchyshyn | 2013-04-18 21:17:39 | Re: [PERFORM] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object |
| Previous Message | Tom Lane | 2013-04-18 14:46:57 | Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan |