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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
Дата
Msg-id 20170131165122.rgostkpgt6tkv6is@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).  (Nikolai Zhubr <n-a-zhubr@yandex.ru>)
Ответы Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
Список pgsql-general
On 2017-01-31 11:45:33 +0300, Nikolai Zhubr wrote:
> 31.01.2017 10:37, I wrote:
> > [...]
> > > > 1. "select localtimestamp" 40 times (As separate requests, one by
> > > > one, but
> > > > no delay inserted in between)
> > > > 2. wait 1/2 second.
> > > > 3. goto 1
> > >
> > > Craig, could this be a side-effect of 519b0757? That's new in 9.5, and
> > > that's directly related to the code paths discussed here.
> >
> > Meanwhile I'll redo my tests using 9.4 instead of 9.5 and report back.
>
> Exactly same trouble with 9.4 (Specifically EDB 9.4.10-1 win32)

That's good to know, less because of 519b0757, more because of the latch
changes - but they also went in in 9.5...

> Would it make sense to check some even older ones?

Could you use process monitor or such to see what the process is doing
while using a lot of CPU?

Regards,

Andres


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

Предыдущее
От: Egon Frerich
Дата:
Сообщение: Re: [GENERAL] Why is table not found?
Следующее
От: Nikolai Zhubr
Дата:
Сообщение: Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).