Re: statistics collector process is thrashing my cpu

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: statistics collector process is thrashing my cpu
Дата
Msg-id 20080527103516.0bdaa25b@mha-laptop.hagander.net
обсуждение исходный текст
Ответ на Re: statistics collector process is thrashing my cpu  ("William Temperley" <willtemperley@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: [PERFORM] select query takes 13 seconds to run with index
Следующее
От: aasat
Дата:
Сообщение: array of composite types to refcusor