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:t...@sss.pgh.pa.us] Sent: Tuesday, January 08, 2013 7:17 PM To: Benjamin Krajmalnik Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] General queston on getting rid of unused WAL files "Benjamin Krajmalnik" <k...@servoyant.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
