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 по дате отправления: