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

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: [GENERAL] core system is getting unresponsive because over 300cpu load
Дата
Msg-id CAGnEboi02r5_Qez4n20WxKqRZq-y1gGrpRUQJ=wz6vZrgP1RQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Ответы Re: [GENERAL] core system is getting unresponsive because over 300 cpu load
Список pgsql-general
Дерево обсуждения
2017-10-11 0:53 GMT+03:00 pinker <pinker@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

В списке pgsql-general по дате отправления: