Обсуждение: Postmaster taking up 100% of CPU

Hi,everyone

The CPU of my linux box is 100% by postmaster processes for hours.
How to deal with it?
The following is my top log and ps log:

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 8970 postgres  16   0 53692  36m  34m R 27.3  3.6   1:14.80 postmaster
 8807 postgres  16   0 53696  36m  34m R 27.0  3.6   1:26.62 postmaster
 8653 postgres  16   0 53696  36m  34m R 23.7  3.6   1:32.29 postmaster
 8961 postgres  16   0 53692  36m  34m R 21.7  3.6   1:36.59 postmaster

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