| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
| Subject: | Re: Stats collector on rampage (8.2.3) |
| Date: | 2007-10-29 09:51:25 |
| Message-ID: | 4725AD1D.4040200@dunslane.net |
| Views: | Whole Thread | Raw Message | 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.
>
>
>
you do realize that this upgrade wouldn't require a dump/restore, don't
you? It would be close to instantaneous.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2007-10-29 10:02:13 | Re: Stats collector on rampage (8.2.3) |
| Previous Message | Magnus Hagander | 2007-10-29 09:47:51 | Re: Stats collector on rampage (8.2.3) |