Bob Lunney <bob_lun...@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to