X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 29DB3D1D278 for ; Fri, 6 Feb 2004 20:40:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85833-07 for ; Fri, 6 Feb 2004 16:40:50 -0400 (AST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by svr1.postgresql.org (Postfix) with ESMTP id 633ADD1B4B7 for ; Fri, 6 Feb 2004 16:40:48 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040206203941.HQIL189272.fep03-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 6 Feb 2004 15:39:41 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id BEC5C3F3A; Fri, 6 Feb 2004 15:40:48 -0500 (EST) Date: Fri, 6 Feb 2004 15:40:48 -0500 From: Andrew Sullivan To: "pgsql-admin@postgresql.org" Subject: Re: Recycled Log Files Message-ID: <20040206204048.GE22668@phlogiston.dyndns.org> Mail-Followup-To: "pgsql-admin@postgresql.org" References: <5.1.0.14.2.20040206112559.034f5a20@imap.eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.1.0.14.2.20040206112559.034f5a20@imap.eldocomp.com> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 6 Feb 2004 15:39:40 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/87 X-Sequence-Number: 12261 On Fri, Feb 06, 2004 at 11:34:18AM -0700, Naomi Walker wrote: > We are running Postgres 7.3.4 on Solaris 6 on an E3500. I noticed the > following messages, and attempted to remedy the situation by upping our > wal_buffers to 64, thinking we might need more room. wal_files seems to > have gone away in this version or I would have increased that as well. > Actually, this is a good thing: it means the logs are getting cleared and available for re-use. But what I'm wondering is why you're going through them so fast. What are you doing in this period? A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland