Re: core system is getting unresponsive because over 300 cpu load

2017-10-11 0:53 GMT+03:00 pinker <pinker(at)onet(dot)eu>:

> > Can you provide output of `iostat -myx 10` at the “peak” moments, please?
>
> sure, please find it here:
> https://pastebin.com/f2Pv6hDL

Looks like `sdg` and `sdm` are the ones used most.
Can you describe what's on those devices? Do you have WAL and DB sitting
together?
Where DB log files are stored?

Here you'll find the
> full bgwriter stats: https://pastebin.com/VA8pyfXj

Can you, please, provide the output of this query (linked from the article
mentioned):
https://gist.github.com/lesovsky/4587d70f169739c01d4525027c087d14

And also this query:
SELECT name,version,source FROM pg_settings WHERE source NOT IN
('default','override');

--
Victor Yegorov