"ITAGAKI Takahiro" <[EMAIL PROTECTED]> writes: > WAL Writer requests unnecessary checkpoints with CHECKPOINT_CAUSE_XLOG. > RedoRecPtr, declared in xlog.c, is initialized at StartupXLOG() but never > updated in WAL Writer because it never calls XLogInsert(). It judges excess > of segments wrongly.
Good catch. I think the best fix for this is to make XLogWrite call GetRedoRecPtr and recheck the condition before actually sending a signal. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster