| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru> |
| Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, Craig Ringer <craig(dot)ringer(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). |
| Date: | 2017-01-31 16:51:22 |
| Message-ID: | 20170131165122.rgostkpgt6tkv6is@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolai Zhubr | 2017-01-31 22:02:11 | Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). |
| Previous Message | Egon Frerich | 2017-01-31 14:17:52 | Re: Why is table not found? |