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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
