Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx <mailto:davidr@xxxxxxxxxxx>

On Sun, Feb 12, 2017 at 12:23 PM, Nikolai Zhubr <n-a-zhubr@xxxxxxxxx
<mailto:n-a-zhubr@xxxxxxxxx>> 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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux