higeon wrote:
> The following is my top log and ps log:
Try using "top -c" on Linux instead. Then you'll be able to see what
all the processes are doing. Any heavy query will cause a CPU to
consume 100% of its time when running, so there may be nothing wrong
other than you have queries to optimize better.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us