"Mr. Dan" <[EMAIL PROTECTED]> writes: > I have checkpoint_segments set to 18, yet I have 38 segmnet files in > pg_xlog. Is there a reason for that?
The normal steady state is about 2N segment files, because we keep the
last two checkpoints' worth of WAL data.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
