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