Thread: Large Number of Files in pg_xlog
Is it possible to reduce the number of files in pg_xlog. Currently, checkpoint_segments is set to 512, which if I understandcorrectly, means there could be up to 1025 files in pg_xlog, 16Gb of WAL. Right now there are 833 files. I'vetried setting checkpoint_segments to a lower number and restarting the database, but to no avail. Is there another methodthat doesn't involve running a dump, initdb, and restore? Thanks in advance, Bob Lunney
Bob Lunney <bob_lunney@yahoo.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