Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C41E6477182 for ; Fri, 24 Jan 2003 14:26:56 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 1937B4773A2 for ; Fri, 24 Jan 2003 13:46:50 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030124184651.ETFT8666.lakemtao03.cox.net@[192.168.1.1]> for ; Fri, 24 Jan 2003 13:46:51 -0500 Subject: Re: Crash Recovery, pt 2 From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <20030124104834.B32645@mail.libertyrms.com> References: <2147483647.1043361178@[10.0.1.133]> <20030124082219.B26558@mail.libertyrms.com> <1043417539.29437.82.camel@haggis> <20030124104834.B32645@mail.libertyrms.com> Content-Type: text/plain Organization: Message-Id: <1043434008.30882.8.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 24 Jan 2003 12:46:49 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/287 X-Sequence-Number: 934 On Fri, 2003-01-24 at 09:48, Andrew Sullivan wrote: > On Fri, Jan 24, 2003 at 08:12:19AM -0600, Ron Johnson wrote: > > > On commercial databases, there's a command to flush the roll-forward > > logs to tape at intervals during the day. > > [. . .] > > > Are there any FM's that explain how this works in Postgres? > > Not yet, because you can't do it. > > There is, I understand, some code currently being included in 7.4 to > do this. So that's when it'll happen. Look for "point in time > recovery" or "PITR" on the -hackers list to see the progress. Great! That's a big step towards enterprise functiomality. Another big step would be aggregate functions using indexes, but that's been discussed before... -- +---------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Fear the Penguin!!" | +---------------------------------------------------------------+