From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net> |
Subject: | Re: Stats collector on rampage (8.2.3) |
Date: | 2007-10-29 10:02:13 |
Message-ID: | 4725AFA5.7040906@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Magnus Hagander wrote:
> Gaetano Mendola wrote:
>> hubert depesz lubaczewski wrote:
>>> On Mon, Oct 29, 2007 at 09:52:24AM +0100, Gaetano Mendola wrote:
>>>> it seems that the stats collector on my box is using more CPU than
>>>> it did in the past.
>>> it's well known bug, and it was fixed in 8.2.4:
>>> http://www.postgresql.org/docs/current/interactive/release-8-2-4.html
>>> ...
>>> Prevent the statistics collector from writing to disk too frequently
>>> (Tom)
>>> ...
>> I saw that, upgrading the DB at this very moment is not doable, killing
>> that process will the postmaster respawn another one? BTW I discover that
>> it was triggered by the time change due the daylight saving.
>
> IIRC, it will. You need to change postgresql.conf and disable the stats
> collector. If you do that, it won't be started.
>
> Shouldn't be trigged by DST.
The high cpu usage started at that time, may be that is another problem of some
applications stuck on it. I will investigate further.
Gaetano
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2007-10-29 10:08:08 | Re: Stats collector on rampage (8.2.3) |
Previous Message | Andrew Dunstan | 2007-10-29 09:51:25 | Re: Stats collector on rampage (8.2.3) |