Bob Lunney <bob_lunney(at)yahoo(dot)com> writes:
> Is it possible to reduce the number of files in pg_xlog. Currently,
> checkpoint_segments is set to 512, which if I understand correctly,
> means there could be up to 1025 files in pg_xlog, 16Gb of WAL. Right
> now there are 833 files. I've tried setting checkpoint_segments to a
> lower number and restarting the database, but to no avail.
Patience. It'll trim down the number of files when it gets around
to it (probably at the next checkpoint, but I don't recall the
exact conditions).
regards, tom lane