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