Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9697D9F9FE8 for ; Wed, 29 Aug 2007 18:29:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 20070-05 for ; Wed, 29 Aug 2007 18:28:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 82B059FA002 for ; Wed, 29 Aug 2007 18:28:56 -0300 (ADT) Received: from [192.168.0.3] (84-12-84-169.dyn.gotadsl.co.uk [84.12.84.169]) by smtp.nildram.co.uk (Postfix) with ESMTP id BC8CA2B6D4F; Wed, 29 Aug 2007 22:28:50 +0100 (BST) Subject: Re: Final status of projects? From: Simon Riggs To: "Florian G. Pflug" Cc: Josh Berkus , pgsql-students@postgresql.org In-Reply-To: <46D5B238.1040006@phlo.org> References: <200708291042.31584.josh@agliodbs.com> <46D5B238.1040006@phlo.org> Content-Type: text/plain Date: Wed, 29 Aug 2007 22:25:45 +0100 Message-Id: <1188422745.4199.14.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/14 X-Sequence-Number: 101 On Wed, 2007-08-29 at 19:51 +0200, Florian G. Pflug wrote: > Josh Berkus wrote: > > Students & Mentors, > > > > I'd like to know how all of your projects came out. I know about a few of > > them, but not a lot of the others: > > > > Florian -- still working on HOT Standby > PITR standby you mean, I think ;-) Hmmm, well if we say Hot Standby rather than HOT Standby. We need to differentiate what we have now ("warm") with what we hope to achieve ("hot"). (I do have to say I've been amazed at how many people seem to have confused what Florian is working on). > I have completed an early prototype. Since the pencils-down dealine of > GSoC has already passed (It was 20th August), I'm currently working on > a patch to lazily assign XIDs. This is a generalization of a part of > my GSoC work, since readonly queries on PITR standby instances need to > be able to run without a real XID too (We cannot generate XIDs on the > standby, they might conflict with those generated on the master). > > If this patch should go in, it'll remove one obstacle from the way > to readonly-queries on PITR slaves, and make the rest of the patch > a great deal less intrusive. I'm very happy with what has been achieved, but we really should regard this as research and not committable code. In this case, the idea of "pencils down" doesn't make any sense. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com