X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 63928533B2 for ; Mon, 16 May 2005 01:40:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08519-01 for ; Mon, 16 May 2005 04:40:49 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 54981533AB for ; Mon, 16 May 2005 01:40:49 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA007A6764; Mon, 16 May 2005 00:41:22 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Mon, 16 May 2005 04:41:22 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE3004A387B; Mon, 16 May 2005 00:41:21 -0400 Received: from localhost (200.85.219.173) by cluster.surnet.cl (7.0.024) id 4276578F001DF284; Mon, 16 May 2005 00:40:46 -0400 Received: by localhost (Postfix, from userid 1000) id A508AC32DDE; Mon, 16 May 2005 00:40:53 -0400 (CLT) Date: Mon, 16 May 2005 00:40:53 -0400 From: Alvaro Herrera To: Josh Berkus Cc: David Parker , pgsql-performance@postgresql.org Subject: Re: checkpoint segments Message-ID: <20050516044053.GB9292@surnet.cl> References: <07FDEE0ED7455A48AC42AC2070EDFF7C74609A@corpsrv2.tazznetworks.com> <200505152026.02262.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200505152026.02262.josh@agliodbs.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.25 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, RCVD_IN_BL_SPAMCOP_NET, RCVD_IN_NJABL_PROXY X-Spam-Level: *** X-Archive-Number: 200505/300 X-Sequence-Number: 12464 On Sun, May 15, 2005 at 08:26:02PM -0700, Josh Berkus wrote: > David, > > > I've seen these messages in the log before, and am aware of the need to > > increase checkpoint_segments, but I wasn't aware that recycling a > > transaction log could be that damaging to performance. There may have > > been some local hiccup in this case, but I'm wondering if recycling is > > known to be a big hit in general, and if I should strive to tune so that > > it never happens (if that's possible)? > > Yes, and yes. Simply allocating more checkpoint segments (which can eat a > lot of disk space -- requirements are 16mb*(2 * segments +1) ) will prevent > this problem. Hmm? I disagree -- it will only make things worse when the checkpoint does occur. -- Alvaro Herrera () "Lo esencial es invisible para los ojos" (A. de Saint Exúpery)