Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BDCA29FA303 for ; Fri, 2 Nov 2007 01:45:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99320-04 for ; Fri, 2 Nov 2007 01:44:58 -0300 (ADT) X-Greylist: from auto-whitelisted 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 61FFB9FA2FF for ; Fri, 2 Nov 2007 01:44:59 -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 M2007110200445808556 for ; Fri, 02 Nov 2007 00:44:58 -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:44:58 -0400 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Re: Understanding wal segments Date: Thu, 1 Nov 2007 22:39:07 -0600 User-Agent: KMail/1.9.7 References: <200711012155.16409.kevin@kevinkempterllc.com> <21716.1193978282@sss.pgh.pa.us> In-Reply-To: <21716.1193978282@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200711012239.07980.kevin@kevinkempterllc.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL=-0.009, BAYES_05=-1.11, DNS_FROM_OPENWHOIS=1.13 X-Spam-Level: X-Archive-Number: 200711/13 X-Sequence-Number: 27256 On Thursday 01 November 2007 22:38:02 Tom Lane wrote: > Kevin Kempter writes: > > What's the relationship between wal_buffers and checkpoint_segments? > > None particularly. > > > 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 ? > > The system is designed to settle at 2*checkpoint_segments+1 files in > pg_xlog, assuming that you have activity spikes sufficient to drive it > up to that level at all. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq makes sense. our system cetrtianly has the activity needed to push it to that level. I turned on wal archivint 1hr & 10min ago and I already have 135 wal segments in my archive directory. I'm running a file system backup, I did a pg_start_backup and now I'm running the tar. Will this affect the transaction activity? I thought it would not. Also I suspect after each filesystem backup I should remove the older archived segments since the file system backup makes them irrelevant. Is this accurate? Thx /Kevin