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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).
Date: 2017-02-14 02:26:31
Message-ID: CAB7nPqQrGiXz8ghmDGiNi3gz=5LQp-VSGOQmu6mNWDkSmSXreQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 14, 2017 at 7:03 AM, Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru> wrote:
> 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?

Not exactly, it checks also if the server is able to accept
connections or refusing them, after establishing the connection. The
real deal is in that. For example it is possible to use pg_isready as
well on a hot standby refusing connections because it did not reach
yet a consistent point.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-02-14 02:59:04 Re: xmlelement AND timestamps.
Previous Message David G. Johnston 2017-02-14 02:10:40 Re: xmlelement AND timestamps.