We have Linux Mint 17.3, postgresql 9.5, i5, ssd raid 0, base and system on different disks.
No matter how I set up the config, there are always such drawdowns. Where to dig?

fsync = on full_page_writes = on synchronous_commit = off

I tried with fsync turned off, the situation has not changed.

upd. It is noticed that if the connections are ~ 100, then the load is as above, but if we increase it to 1000, then it’s quite sad:

  • Is it that the processor is not loaded is bad? Maybe at this time you do not have tasks that eat everything 100% - Mike
  • Notice how the network and processor graphics synchronously change. It is obvious that from time to time the base does not need its consumers, apparently it is they who have some interruptions in work. - avp
  • I will clarify, the server task is synchronization of constant data to clients. During the drawdown, there is still data, customers have confirmed the reception of the previous packet. Those. There are no grounds for the server to stand idle. - Vladimir

0