On 2015-10-03 01:39:33 -0700, ajaykbs wrote: > It is observed that at some times during moderate load > the CPU usage goes up to 400% and the users are not able to complete the > queries in expected time. But the load is contributed by some system process > only.The average connections are normally 50. This email is nearly impossible to read. But it sounds a bit like you need to disable transparent hugepages and/or zone_reclaim mode. Greetings, Andres Freund -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance