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 31BA1D1D7FA for ; Fri, 6 Feb 2004 19:25:15 +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 56805-03 for ; Fri, 6 Feb 2004 15:25:10 -0400 (AST) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id 70BF4D1DA34 for ; Fri, 6 Feb 2004 15:25:07 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040206192202.GJAT391676.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 6 Feb 2004 14:22:02 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 41D2C3F3F; Fri, 6 Feb 2004 14:25:02 -0500 (EST) Date: Fri, 6 Feb 2004 14:25:02 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: hanging for 30sec when checkpointing Message-ID: <20040206192502.GB22668@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <40202216.4010608@shanewright.co.uk> <56DEF96A-5888-11D8-85B9-000393A5890E@shanewright.co.uk> <29986.1076081586@sss.pgh.pa.us> <9BB17A7C-58C7-11D8-918E-000393A5890E@shanewright.co.uk> <1529.1076088887@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1529.1076088887@sss.pgh.pa.us> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 6 Feb 2004 14:22:02 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/86 X-Sequence-Number: 12260 On Fri, Feb 06, 2004 at 12:34:47PM -0500, Tom Lane wrote: > Mmm, right, I forgot to mention that one, which was a bit silly > considering that that was the focus of the discussion. No, infrequent > checkpoints won't hurt performance between checkpoints. In my experience, though, they do hurt _quite substantially_ during the checkpoint. If you need fast all the time, cranking that interval too high will definitely hurt you. A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun