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. Is there another method that doesn't involve running a dump, initdb, and restore?

Thanks in advance,

Bob Lunney




--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Bob Lunney <bob_lunney [at] 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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin