Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsmKW-0008Ey-Gs for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2013 03:27:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TsmKV-0002PL-LI for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2013 03:27:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsmKU-0002PG-Vz for pgsql-admin@postgresql.org; Wed, 09 Jan 2013 03:27:51 +0000 Received: from [64.207.29.137] (helo=mail.illumen.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsmKR-0002Tu-2k for pgsql-admin@postgresql.org; Wed, 09 Jan 2013 03:27:50 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: General queston on getting rid of unused WAL files Date: Tue, 8 Jan 2013 20:27:34 -0700 Message-ID: In-Reply-To: <8318.1357697800@sss.pgh.pa.us> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] General queston on getting rid of unused WAL files Thread-Index: Ac3uD14+iya/EDmSScSGhN1XraywywACUT9Q References: <8318.1357697800@sss.pgh.pa.us> From: "Benjamin Krajmalnik" To: "Tom Lane" Cc: X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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@sss.pgh.pa.us]=20 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" writes: > Looking at pg_xlogs, I see that postgres is sequentially reusing all=20 > of the available WAL files, while looking at the log file, it is=20 > recycling approximately 70-80 files every checkpoint, but it is not=20 > 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 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin