Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E3EFE37BA4B for ; Tue, 7 Oct 2008 13:06:48 -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 34207-06 for ; Tue, 7 Oct 2008 13:06:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail129174.authsmtp.net (outmail129174.authsmtp.net [62.13.129.174]) by postgresql.org (Postfix) with ESMTP id A23F837BA42 for ; Tue, 7 Oct 2008 13:06:42 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m97G62Rb074868; Tue, 7 Oct 2008 17:06:02 +0100 (BST) Received: from [192.168.0.3] (85-211-69-124.dyn.gotadsl.co.uk [85.211.69.124]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m97G60EY048309; Tue, 7 Oct 2008 17:06:00 +0100 (BST) Subject: Re: [PATCHES] Infrastructure changes for recovery From: Simon Riggs To: Heikki Linnakangas Cc: Alvaro Herrera , Tom Lane , Andrew Dunstan , pgsql-hackers In-Reply-To: <48EB7E11.4010603@enterprisedb.com> References: <1221745847.3913.2408.camel@ebony.2ndQuadrant> <18549.1221746983@sss.pgh.pa.us> <1222121161.4445.248.camel@ebony.2ndQuadrant> <1222184541.4445.400.camel@ebony.2ndQuadrant> <28973.1222381719@sss.pgh.pa.us> <1222985488.4445.1625.camel@ebony.2ndQuadrant> <48E5544B.5050103@dunslane.net> <1223367445.4747.105.camel@ebony.2ndQuadrant> <13866.1223388527@sss.pgh.pa.us> <1223389637.4747.194.camel@ebony.2ndQuadrant> <20081007143707.GA19440@alvh.no-ip.org> <48EB7E11.4010603@enterprisedb.com> Content-Type: text/plain Date: Tue, 07 Oct 2008 17:07:46 +0100 Message-Id: <1223395666.4747.228.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: d5b7f455-9489-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFaAJbYlpF HGQLW1xEUVp7WWV/ awofZQBDYEtPQQNj TklLRk1QEQdtHhxP WxcZJR9yAmxGfHZz ZU8sXHJfWQoucBR6 FEpREHAPYW9pdWEe BBRFfwJRdR5Kfh5E YlUrV3QKMjRJBC9q VzwLFgwaHRhkHWxm YigmDn8oenNDPzgy XRkZAS8yFlEYXSh7 JBwvLFERBw4fNV96 K1YqXkwVKQ56 X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/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: 200810/270 X-Sequence-Number: 125287 On Tue, 2008-10-07 at 18:19 +0300, Heikki Linnakangas wrote: > The bottom line is that hot standby is a big feature, and probably a big > patch. No amount of version control will work around that. Finishing all > that in a few weeks is a very ambitious goal. I wish you luck, and I > wish I could do more to help you with that; it's a feature I'd really > like to see in 8.4. Given how many iterations just this part of the > patch needed, and it's still not there, the little project manager in me > says that we really need to be seeing the complete patch or patches very > soon, and do a first round of review well before the commit fest. The > risk that we have to drop it as unfinished in November is very high > otherwise. Agreed and understood. The coding isn't the problem, its the risk of being blindsided by a showstopper. Coding is quick when you know exactly what you are trying to achieve. That's one reason to strip out the bgwriter stuff. It's the postmaster state change stuff that's most needed. Anyway, watch this space. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support