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

Поиск
Список
Период
Сортировка
От Nikolai Zhubr
Тема Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).
Дата
Msg-id 58A2DBDC.7040802@yandex.ru
обсуждение исходный текст
Ответ на Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).  (John R Pierce <pierce@hogranch.com>)
Ответы Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).  ("Rader, David" <davidr@openscg.com>)
Список pgsql-general
14.02.2017 12:47, John R Pierce:
> On 2/13/2017 11:03 PM, Nikolai Zhubr wrote:
>> Now I'd like to locate a CPU eater more precisely - supposedly there
>> is some issue with communication, that is why I don't want to mix in
>> anything else.
>
> use iperf to test the network transport layer, without any postgres in
> the loop?

No, the network performance in general is fine. However, some specific
continuous communication pattern causes something to go very wrong on
windows periodically. (And there is no such problem on linux btw) While
the issue now seems rather related to windows itself and not postgres,
but the pattern typical for some of my postgres uses is apparently a
reliable trigger. Therefore, I'm thinking to first isolate the problem
inside postgres, and if it still triggers then, second step, create a
test "server" consisting of communication code of postgres to run
without any other parts of postgres.


Regards,
Nikolai

>
>



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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).
Следующее
От: Dave Page
Дата:
Сообщение: [GENERAL] PostgreSQL Code of Conduct Draft