Re: Stats collector on rampage (8.2.3)

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Subject: Re: Stats collector on rampage (8.2.3)
Date: 2007-10-29 09:37:39
Message-ID: 4725A9E3.3080005@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2007-10-29 09:45:36 Re: Stats collector on rampage (8.2.3)
Previous Message hubert depesz lubaczewski 2007-10-29 09:18:24 Re: Stats collector on rampage (8.2.3)