Alvaro Herrera <[EMAIL PROTECTED]> writes: > Ok, so there's a reason for having a manual stat-reset. However what's > the rationale for cleaning stats at postmaster start? In fact I think > it's actively bad because you lose any data you had before postmaster > stop/crash.
We probably *should* drop the stats file if any WAL replay activity occurs, because the stats file could be out of sync with reality --- this is particularly important in a PITR recovery situation, where the stats file is likely to be WAY out of sync. (Maybe only clobber it in PITR mode?) I agree that the argument for doing it in a normal restart is pretty weak. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster