Skip site navigation (1) Skip section navigation (2)

Re: statistics collector process is thrashing my cpu

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: "William Temperley" <willtemperley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: statistics collector process is thrashing my cpu
Date: 2008-05-27 08:35:16
Message-ID: 20080527103516.0bdaa25b@mha-laptop.hagander.net (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

Next:From: aasatDate: 2008-05-27 08:48:12
Subject: array of composite types to refcusor
Previous:From: hubert depesz lubaczewskiDate: 2008-05-27 08:22:01
Subject: Re: [PERFORM] select query takes 13 seconds to run with index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group