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 20170203191640.6s5ebxzsj7vm37xo@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).  (Nikolai Zhubr <n-a-zhubr@yandex.ru>)
List pgsql-general
On 2017-02-03 22:17:55 +0300, Nikolai Zhubr wrote:
> 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.)

I'm missing something. All you need to do is to start
processexplorer.exe and filter out other applications?

Andres


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).
Next
From: Nikolai Zhubr
Date:
Subject: Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5(EDB binary).