"Mr. Dan" <bitsandbytes88@xxxxxxxxxxx> 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