It is set to 1024 (I had set it to that level just in case it was needed due to a peak in workload), and presently I have 2121 WAL files. Thanks for the info - just reduced it to 256, and will go form there. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Tuesday, January 08, 2013 7:17 PM To: Benjamin Krajmalnik Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: General queston on getting rid of unused WAL files "Benjamin Krajmalnik" <kraj@xxxxxxxxxxxxx> writes: > Looking at pg_xlogs, I see that postgres is sequentially reusing all > of the available WAL files, while looking at the log file, it is > recycling approximately 70-80 files every checkpoint, but it is not > removing any files. [ squint... ] It should be removing those files until it gets under approximately 2 * checkpoint_segments WAL files. So, what have you got checkpoint_segments set to? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
