X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 495ADD1B1CD for ; Mon, 19 Jul 2004 19:14:35 -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 25717-06 for ; Mon, 19 Jul 2004 22:14:28 +0000 (GMT) Received: from cmailg2.svr.pol.co.uk (cmailg2.svr.pol.co.uk [195.92.195.172]) by svr1.postgresql.org (Postfix) with ESMTP id 31A61D1B182 for ; Mon, 19 Jul 2004 19:14:25 -0300 (ADT) Received: from modem-856.orangutan.dialup.pol.co.uk ([217.135.227.88] helo=[192.168.0.100]) by cmailg2.svr.pol.co.uk with esmtp (Exim 4.14) id 1BmgOv-0001qh-0T; Mon, 19 Jul 2004 23:14:25 +0100 Subject: Re: [HACKERS] Point in Time Recovery From: Simon Riggs To: Tom Lane Cc: Bruce Momjian , markw@osdl.org, kn@mgnet.de, pgsql-patches@postgresql.org In-Reply-To: <23306.1090256164@sss.pgh.pa.us> References: <200407191635.i6JGZ5A21033@candle.pha.pa.us> <23306.1090256164@sss.pgh.pa.us> Content-Type: text/plain Organization: 2nd Quadrant Message-Id: <1090275263.28049.378.camel@stromboli> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Mon, 19 Jul 2004 23:14:24 +0100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/313 X-Sequence-Number: 11983 On Mon, 2004-07-19 at 17:56, Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> I had second thoughts about that and didn't do it in the committed > >> patch, though it's certainly still open for debate. > > > How are we handling a crash during recovery? > > Retry, perhaps. It doesn't seem any different from crash-during-recovery > in the non-archived scenario ... > Well, a recovery is just re-applying already written logs at super speed. We don't need to write WAL because we already wrote it once (and that would really confuse the timeline issue). I think if this was an issue, the solution would be to speed up recovery since that would benefit us more than putting recovery-squared code in. Just start over... Best Regards, Simon Riggs