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

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
>