The PostgreSQL processes are suffering from high CPU utilization

Solution Verified - Updated -

Issue

From top command, each thread of postmaster was suffering high CPU utilization:

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                        
20161 ovirt     20   0 20.0g 4.4g  18m S 141.2 14.0 193:52.46 java                                                                                                          
20723 postgres  20   0 5523m 117m  49m R 93.3  0.4  61:57.85 postmaster                                                                                                     
20604 postgres  20   0 5527m 116m  49m R 88.1  0.4  54:26.44 postmaster                                                                                                     
20823 postgres  20   0 5523m 115m  48m R 87.5  0.4  55:58.31 postmaster                                                                                                     
.....omitted.....

Environment

Red Hat Enterprise Virtualization 3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content