Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TslDo-00074Z-Mu for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2013 02:16:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TslDo-0003oq-5Y for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2013 02:16:52 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TslDf-0003h4-1B for pgsql-admin@postgresql.org; Wed, 09 Jan 2013 02:16:43 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TslDd-0002hG-B0 for pgsql-admin@postgresql.org; Wed, 09 Jan 2013 02:16:42 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r092GeW7008319; Tue, 8 Jan 2013 21:16:40 -0500 (EST) From: Tom Lane To: "Benjamin Krajmalnik" cc: pgsql-admin@postgresql.org Subject: Re: General queston on getting rid of unused WAL files In-reply-to: References: Comments: In-reply-to "Benjamin Krajmalnik" message dated "Tue, 08 Jan 2013 18:55:33 -0700" Date: Tue, 08 Jan 2013 21:16:40 -0500 Message-ID: <8318.1357697800@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) 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 "Benjamin Krajmalnik" 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