Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 861BE9FA2FF for ; Fri, 2 Nov 2007 01:16:25 -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 40608-03 for ; Fri, 2 Nov 2007 01:16:12 -0300 (ADT) X-Greylist: delayed 00:15:02.938245 by SQLgrey-1.7.5 Received: from s-utl02-atpop.stsn.net (s-utl02-atpop.stsn.net [72.254.128.202]) by postgresql.org (Postfix) with SMTP id B454C9FA31E for ; Fri, 2 Nov 2007 01:16:10 -0300 (ADT) Received: from s-utl02-atpop.stsn.net ([127.0.0.1]) by s-utl02-atpop.stsn.net (SMSSMTP 4.1.2.20) with SMTP id M2007110200010608425 for ; Fri, 02 Nov 2007 00:01:06 -0400 Received: from [10.4.153.241] ([10.4.153.241]) by s-utl02-atpop.stsn.net for pgsql-admin@postgresql.org; Fri, 2 Nov 2007 00:01:06 -0400 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Understanding wal segments Date: Thu, 1 Nov 2007 21:55:15 -0600 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200711012155.16409.kevin@kevinkempterllc.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/11 X-Sequence-Number: 27254 Hi List; I'm wanting to better understand wal / checkpoint segments. I have a cluster which has checkpoint_segments set to 32 and wal_buffers set to 24. I see consistently 66 files in pg_xlog and I've recently implemented wal archiving and so far there are 41 segments/files in the wal archive dir. What's the relationship between wal_buffers and checkpoint_segments? even though the max distance between checkpoints is 32 segments, is there something that controls the number of files/segments in the pg_xlog dir ? Thanks in advance /Kevin