Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).

Поиск
Список
Период
Сортировка
От Nikolai Zhubr
Тема Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
Дата
Msg-id 58A09A0D.2000503@yandex.ru
обсуждение исходный текст
Ответ на Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).  (Nikolai Zhubr <n-a-zhubr@yandex.ru>)
Ответы Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).  ("Rader, David" <davidr@openscg.com>)
Список pgsql-general
Hello all,

In order to locate the problem more precisely, I'd like to prepare a
test, involving some ping-like communication between the server and a
test client. That is, I'd like to repeatedly send something valid to the
server and get some valid replies from it, but without any kind of real
activity happening on the server. I've looked through the main loop in
PostgresMain() but could not find any suitable candidates.

Any thoughts?

Thank you.

Nikolai


03.02.2017 16:30, I wrote:
[...]
> Ok, secure_read() is likely irrelevant too.
>
> I think what happened after I inserted "Sleep(15)" into secure_read() is
> that this "Sleep(15)" was essentially added into the main "for(;;)" loop
> of PostgresMain (through ReadCommand), introducing an artifical
> additional CPU relaxation step along with every incoming query and
> therefore just masking a real CPU eater.
>
> So probably I'll have to somehow profile this "for(;;)" in PostgresMain.
>
>
> Thank you.
>
> Nikolai
>



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: [GENERAL] Custom shuffle function stopped working in 9.6