If the process hogging CPU is the one serving the abnormally disconnected client, then you did the right thing. When the client aborts and the network connection is not completely shut down, the shadow process will hang around. If the database is very busy, pmon may not have time to do cleanup.
Yong Huang
> 当时没有留意在KILL客户端进程前对应的服务器进程是否繁忙。
Are you saying you killed the process that used too much CPU without checking to see if that process was the shadow (server) process serving the disconnected client? What if you accidentally killed a legitimate process that was running an important data warehouse job?
Yong Huang