Re: [PERFORM] High CPU usage buy low I/O wait

2013-04-18 Thread k...@rice.edu
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 > fin

[PERFORM] High CPU usage buy low I/O wait

2013-04-18 Thread bing1221
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 p