[PERFORM] Re: Multi processor server overloads occationally with system process while running postgresql-9.4

I have checked the transparent huge pages and zone reclaim mode and those are already disabled. As a trial and error method, I have reduced the shared buffer size from 8500MB to 3000MB. The CPU i/o wait is icreased a little. But the periodical over load has not occurred afterwards. (3 days passed

[PERFORM] Re: Multi processor server overloads occationally with system process while running postgresql-9.4

Sorry about the formatting. I am posting the same lines again. I am working in a public company who uses only open source applications and databases. I have a problem with our critical database which is write and read intensive. version: Postgresql-9.4 Hardware: HP DL980 (8-processor, 80 cores

[PERFORM] Multi processor server overloads occationally with system process while running postgresql-9.4

I am working in a public company who uses only open source applications and databases.I have a problem with our critical database which is write and read intensive.*version:* Postgresql-9.4*Hardware:* HP DL980 (8-processor, 80 cores w/o hyper threading, 512GB RAM)*Operating system: *Red Hat Enterpr