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

From Andres Freund
Subject Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
Date
Msg-id 20170131165122.rgostkpgt6tkv6is@alap3.anarazel.de
Whole thread Raw
In response to Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).  (Nikolai Zhubr <n-a-zhubr@yandex.ru>)
Responses Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
List 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 by date:

Previous
From: Egon Frerich
Date:
Subject: Re: [GENERAL] Why is table not found?
Next
From: Nikolai Zhubr
Date:
Subject: Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).