| From: | Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| 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-02-03 19:17:55 |
| Message-ID: | 5894D763.1050809@yandex.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
03.02.2017 20:29, Andres Freund:
[...]
>>> Could you use process monitor or such to see what the process is doing
>>> while using a lot of CPU?
>>
>> I'm not sure how to do this, especially considering that the process in
>> question is running as a service?
>
> I don't think that stops you, if you have admin privileges.
Well, profiling postgres.exe is still beyond my capability at this time
anyway. Instead, I'll try to prepare a most simple client application
example for testing the behaviour in question so that anyone could run
it easily. (And while working on such an example, maybe I'll get some
more understanding of what is actually going on here.)
Thank you.
Nikolai
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hu, Patricia | 2017-02-03 20:35:13 | Re: PSQL 9.5 select for update locks too many rows when using numeric instead of int |
| Previous Message | Andres Freund | 2017-02-03 19:16:40 | Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). |