Re: statistics collector process is thrashing my cpu - Mailing list pgsql-general

From Magnus Hagander
Subject Re: statistics collector process is thrashing my cpu
Date
Msg-id 20080527103516.0bdaa25b@mha-laptop.hagander.net
Whole thread Raw
In response to Re: statistics collector process is thrashing my cpu  ("William Temperley" <willtemperley@gmail.com>)
List pgsql-general
William Temperley wrote:
> >
> > Actually, that does not mean it's broken. It just says it can't find
> > symbols for where it was - but if this was in ntdll, that's fine. If
> > you bring up the full stacktrace at this point, does it contain
> > proper data?
> >
> > //Magnus
>
>
> Mystery solved, it was PCTools antivirus causing the problem.
> It seems pctlsp.dll was interfering when the stats collector process -
> Prolonged stepping into the hung process showed pctlsp.dll popping
> its head up now and then, and absolutely no postgres code was run at
> all.  It was all happening within ntdll!LdrShutdownThread.
>
> Uninstalling PCTools solved the problem and restored my faith in
> Postgres!

Ah, thanks for letting us know.

//Magnus

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: [PERFORM] select query takes 13 seconds to run with index
Next
From: aasat
Date:
Subject: array of composite types to refcusor