Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 64BB49FB605 for ; Wed, 16 May 2007 13:51:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87632-09 for ; Wed, 16 May 2007 13:51:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 29D529FBA46 for ; Wed, 16 May 2007 13:51:46 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 689C1564AF; Wed, 16 May 2007 11:51:45 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 16 May 2007 11:51:43 -0500 Date: Wed, 16 May 2007 11:51:43 -0500 From: "Jim C. Nasby" To: Keaton Adams Cc: pgsql-admin@postgresql.org Subject: Re: WAL file utilization question Message-ID: <20070516165143.GU14548@nasby.net> References: <1179332909.22514.3.camel@MXLRMT-208.corp.mxlogic.com> <20070516163513.GQ14548@nasby.net> <1179334144.22514.14.camel@MXLRMT-208.corp.mxlogic.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1179334144.22514.14.camel@MXLRMT-208.corp.mxlogic.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070516:kadams@mxlogic.com::Ot2mxlUZRD/7lcwS:0000000000000000000 0000000000000000000000004f8k X-Hashcash: 1:20:070516:pgsql-admin@postgresql.org::sBFg8mNkSBsab9H2:00000000000 0000000000000000000000003x/Q X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/145 X-Sequence-Number: 25465 On Wed, May 16, 2007 at 10:49:04AM -0600, Keaton Adams wrote: > So, if I do set the checkpoint_segments parameter to 50, 75, or even 100 > I will have a considerable number of WAL files in data/pg_xlog, but they > will be used more efficiently, so I will be archiving less? That's what > I understand from the comments received so far. Yes. Let it create 500 or 1000 WAL files if it wants... it's much more important to limit the frequency of checkpoints than to reduce the number of WAL files (which has virtually no impact on performance). -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)