Skip site navigation (1) Skip section navigation (2)

Re: Stats collector on rampage (8.2.3)

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: (view raw or whole 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:
>>> ...
>>> 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.



In response to


pgsql-hackers by date

Next:From: Gaetano MendolaDate: 2007-10-29 10:02:13
Subject: Re: Stats collector on rampage (8.2.3)
Previous:From: Magnus HaganderDate: 2007-10-29 09:47:51
Subject: Re: Stats collector on rampage (8.2.3)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group