Re: High SYS CPU - need advise

Поиск
Список
Период
Сортировка
От Vlad
Тема Re: High SYS CPU - need advise
Дата
Msg-id CAKeSUqXc_2A4tPrAVJ-uSw1wdbt9_ZQprboLGiWL-xodt5=aZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High SYS CPU - need advise  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
I just did a little experiment: extracted top four queries that were executed the longest during stall times and launched  pgbench test with 240 clients. Yet I wasn't able to put the server into a stall with that. Also load average was hitting 120+, it was all user cpu, single digit % system. The system remained pretty responsive (on a keypress), in contrary to when high-sys-cpu stall happens, showing similar LA numbers.

This makes me think that there is probably a different (than ones I tried) query or condition that is responsible for creating high-sys-cpu. Also, from my limited knowledge of postgresql and kernel internals, this experiment puts under question idea that linux scheduler might be the corner stone....

Here is a longer log, first column is PID. High-sys-cpu stall happened around 10:42:37

I'll try to put pgbouncer in place and repeat, also though this will take longer time to setup.


-- Vlad

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

Предыдущее
От: Vlad
Дата:
Сообщение: Re: High SYS CPU - need advise
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: High SYS CPU - need advise