Re: Idle processes chewing up CPU?

On Wed, Jul 29, 2009 at 12:08, Craig Ringer<craig(at)postnewspapers(dot)com(dot)au> wrote:
> Craig Ringer wrote:
>>
>> Brendan Hill wrote:
>>>
>>> Hi Tom,
>>>
>>> Given it's on Windows, any suggestion for how I would get hold of this?
>>> (Process Monitor tool perhaps?)
>>
>> I think you can get stack traces from Process Monitor using "Tools ->
>> Stack Summary". I find it a bit hard to interpret this data, though, and I'm
>> not sure how useful it is for this sort of thing.
>>
>>
>>
>> [ The following instructions may be put on the PostgreSQL wiki as advice
>> for getting debugging details for runaway PostgreSQL processes on Windows if
>> desired ]:
>
> Actually, I've expanded on the instructions and done it. See:
>
> http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
>
> Accessible from "General Articles and Guides" -> "Troubleshooting" ->
> "Generating_a_stack_trace_of_a_PostgreSQL_backend".

This is very useful, thanks for putting it up!

--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/