Andrew Dunstan wrote:

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
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.
Sure I do, for me it's even easier than that, I use DRBD so I can just shut
down one node upgrade it and then upgrade the other one; however upgrade the
DB means for me "touch" an entire satellite trasmission platform, I have to
schedule a platform maintenance for that...

Gaetano Mendola

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 9 of 9 | next ›
Discussion Overview
grouppgsql-hackers @
postedOct 29, '07 at 9:01a
activeOct 29, '07 at 10:07a



site design / logo © 2022 Grokbase