After updating to version 8.3 we have been experiencing higher than usual CPU usage and when I checked it this morning it is running at 99 - 100 percent. When I check the running processes I noticed 2 processes that are hogging the CPU.
postgres 2178 91.4 21.2 913492 708968 ? Rs 07:32 0:45 \_ postgres: reporting reporting [local] SELECT
postgres 30211 55.1 4.1 151692 139548 ? Ss 06:40 29:12 \_ postgres: reporting reporting [local] VACUUM waiting
It seems that these are either stalled or not operating properly. I only use the web interface for administration and have not had a need to use the shell, but is there a way to kill these processes so that the performance of the box can return to normal at least until the problem returns or I can open a ticket to support for help?
Thanks in advance!
This thread was automatically locked due to age.
