13.02.2017 23:58, Rader, David:
> How about using pg_isready?
> https://www.postgresql.org/docs/current/static/app-pg-isready.html
But it doesn't actually communicate with the server AFAIK, just checks
if a connection could be established?
Maybe I should have been more specific.
What I need is debugging/profiling pure communication side of server
operation, implying huge lots of requests and replies going over the
wire to and from the server within some continued (valid) session, but
so that the server is not actually doing anything above that (no sql, no
locking, no synchronizing, zero usefull activity, just pumping network I/O)
Regards,
Nikolai
>
> --
> David Rader
> davidr@openscg.com <mailto:davidr@openscg.com>
>
> On Sun, Feb 12, 2017 at 12:23 PM, Nikolai Zhubr <n-a-zhubr@yandex.ru
> <mailto:n-a-zhubr@yandex.ru>> wrote:
>
> 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
