2017-10-11 0:53 GMT+03:00 pinker <pinker@xxxxxxx>:
> 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
