| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | hubert depesz lubaczewski <depesz(at)depesz(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Stats collector on rampage (8.2.3) |
| Date: | 2007-10-29 09:47:51 |
| Message-ID: | 4725AC47.4000001@hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-10-29 09:51:25 | Re: Stats collector on rampage (8.2.3) |
| Previous Message | Gaetano Mendola | 2007-10-29 09:45:36 | Re: Stats collector on rampage (8.2.3) |