Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3CC7C64FCCC for ; Fri, 12 Sep 2008 15:55:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00230-04 for ; Fri, 12 Sep 2008 15:55:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136014.authsmtp.com (outmail136014.authsmtp.com [62.13.136.14]) by postgresql.org (Postfix) with ESMTP id D5B1664FCC1 for ; Fri, 12 Sep 2008 15:55:54 -0300 (ADT) Received: from punt9.authsmtp.com (punt9.authsmtp.com [62.13.128.70]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m8CItnAZ036126 for ; Fri, 12 Sep 2008 19:55:49 +0100 (BST) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m8CItmfZ041190; Fri, 12 Sep 2008 19:55:48 +0100 (BST) Received: from [192.168.0.2] (85-211-229-97.dyn.gotadsl.co.uk [85.211.229.97]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m8CItlVd050111; Fri, 12 Sep 2008 19:55:47 +0100 (BST) Subject: Re: [HACKERS] Infrastructure changes for recovery From: Simon Riggs To: Alvaro Herrera Cc: Tom Lane , List pgsql-patches In-Reply-To: <20080912181421.GI8854@alvh.no-ip.org> References: <1218109459.4549.423.camel@ebony.2ndQuadrant> <1220213074.4371.173.camel@ebony.2ndQuadrant> <1905.1220895241@sss.pgh.pa.us> <1221080797.3913.768.camel@ebony.2ndQuadrant> <20080912181421.GI8854@alvh.no-ip.org> Content-Type: text/plain Date: Fri, 12 Sep 2008 19:56:06 +0100 Message-Id: <1221245766.3913.1130.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 69680f26-80fc-11dd-bc7a-001f29070be2 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaQdbflxB HGQLW1xEUVV7XGZ/ bw0fZQBDYEtPQQdo WVZARU1QEQdtHhxP WxZtK10uEVFGfX5x ZEcsX3VSXAp8fEB1 QhhWE3AOZTEzdWEe BBRFJVBTIR5Kfh4T aFl/U3NfNGdJBC9q VzwLFgwaHRhkHWxm YigmDn8oenNDPzgy XRkZAS8yFlEYXSh7 JBwvLFERBw4fNV96 K1YqXkwVKQ56 X-Authentic-SMTP: 61633235383639.kestrel.dmpriest.net.uk:1186/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/122 X-Sequence-Number: 7137 On Fri, 2008-09-12 at 14:14 -0400, Alvaro Herrera wrote: > Simon Riggs wrote: > > > --- 5716,5725 ---- > > CheckpointStats.ckpt_sync_end_t, > > &sync_secs, &sync_usecs); > > > > ! elog(LOG, "%s complete: wrote %d buffers (%.1f%%); " > > "%d transaction log file(s) added, %d removed, %d recycled; " > > "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s", > > + (checkpoint ? " checkpoint" : "restartpoint"), > > CheckpointStats.ckpt_bufs_written, > > (double) CheckpointStats.ckpt_bufs_written * 100 / NBuffers, > > CheckpointStats.ckpt_segs_added, > > Very minor nit: this really needs a rework. All I changed was the word "restartpoint"... its otherwise identical to existing message. I'd rather not change that. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support