Re: Stats collector on rampage (8.2.3) - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: Stats collector on rampage (8.2.3)
Date
Msg-id 4725ABC0.4000009@bigfoot.com
Whole thread Raw
In response to Re: Stats collector on rampage (8.2.3)  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Stats collector on rampage (8.2.3)
List 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


pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Stats collector on rampage (8.2.3)
Next
From: Magnus Hagander
Date:
Subject: Re: Stats collector on rampage (8.2.3)