Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A1D9F9F9E10 for ; Wed, 29 Aug 2007 19:14:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 68083-05 for ; Wed, 29 Aug 2007 19:13:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from master.phlo.org (master.phlo.org [213.147.174.89]) by postgresql.org (Postfix) with ESMTP id 4F6169F9D2F for ; Wed, 29 Aug 2007 19:14:00 -0300 (ADT) Received: (qmail 15817 invoked by uid 0); 29 Aug 2007 22:13:58 -0000 Received: from unknown (HELO phlook.client.solution-x.com) (fgp@[10.105.0.26]) (envelope-sender ) by master.phlo.org (qmail-ldap-1.03) with SMTP for ; 29 Aug 2007 22:13:58 -0000 Message-ID: <46D5EFA6.4020406@phlo.org> Date: Thu, 30 Aug 2007 00:13:58 +0200 From: "Florian G. Pflug" User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728) MIME-Version: 1.0 To: Simon Riggs CC: Josh Berkus , pgsql-students@postgresql.org Subject: Re: Final status of projects? References: <200708291042.31584.josh@agliodbs.com> <46D5B238.1040006@phlo.org> <1188422745.4199.14.camel@ebony.site> In-Reply-To: <1188422745.4199.14.camel@ebony.site> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/15 X-Sequence-Number: 102 Simon Riggs wrote: > 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). When I read HOT, I immediatly thought "Heap-Only-Tuples", because I've been reading that patch, to see if we can reuse some ideas for lazy xid assignment. So I didn't even consider that HOT could mean hot ;-) >> 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. Full Ack. The fact that what I do now won't be part of the "official SoC outcome" anyway just made it easier for me to justify my little "lazy XID assignment" detour. greetings, Florian Pflug