Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CDA4C9FB40F for ; Tue, 27 Feb 2007 12:49:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 25258-01 for ; Tue, 27 Feb 2007 12:49:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D5ABF9FB409 for ; Tue, 27 Feb 2007 12:49:21 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id F3BB256448; Tue, 27 Feb 2007 10:49:20 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 27 Feb 2007 10:49:18 -0600 Date: Tue, 27 Feb 2007 10:49:18 -0600 From: "Jim C. Nasby" To: Tom Lane Cc: Andrew Dunstan , pgsql-hackers@postgresql.org Subject: Re: Seeking Google SoC Mentors Message-ID: <20070227164917.GI29041@nasby.net> References: <200702261311.39684.josh@agliodbs.com> <45E34F9F.7090002@dunslane.net> <200702261550.14414.wt@penguintechs.org> <45E36722.1080703@dunslane.net> <9533.1172542238@sss.pgh.pa.us> <20070227044345.GI29041@nasby.net> <12559.1172555234@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <12559.1172555234@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070227:tgl@sss.pgh.pa.us::nl5RhMHEEGtBcTK3:00000000000000000000 0000000000000000000000003Kcz X-Hashcash: 1:20:070227:andrew@dunslane.net::n2U1g1o3v06wNdOv:000000000000000000 0000000000000000000000004B65 X-Hashcash: 1:20:070227:pgsql-hackers@postgresql.org::vDs5X2G1RyNzoz+y:000000000 0000000000000000000000000BwR X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/1709 X-Sequence-Number: 99262 On Tue, Feb 27, 2007 at 12:47:14AM -0500, Tom Lane wrote: > "Jim C. Nasby" writes: > > Yes, but the list being discussed is SoC projects that the community > > would like to see done, which means most people would assume that #1 > > isn't an issue. > > > We need to make sure that every project on the list of SoC ideas is > > supported by the community. > > Agreed, except that in most cases a one-liner description of an idea > isn't enough to get a meaningful reading on whether people think it's > sane or not. To take our current example: do you think a one-liner > description of full disjunctions would have gotten any feedback, except > for requests for more detail? > > I'm not sure how we fix that --- laying out every acceptable project > in great detail in advance won't happen for lack of manpower, and wouldn't > be a good idea even if we could do it, because that sounds like a great > way to stifle creativity. At the same time we can hardly promise to > accept every wild-west idea that someone manages to turn into some kind > of code. What can we tell the students other than "get as much feedback > as you can, as early as you can"? I agree we certainly don't want to go designing these projects in advance, but I think we could at least ensure that the community buys into the concept of each project. ISTM one of the big issues with FD is that most people didn't even really understand what exactly it was or how it might be useful, which made getting broad acceptance even harder. For example, these TODOs seem like they have good acceptance by the community (though they might not be good SoC projects for other reasons): Simplify ability to create partitioned tables Allow auto-selection of partitioned tables for min/max() operations Allow commenting of variables in postgresql.conf to restore them to defaults Examples of ideas that might not be good because it's unclear that the community supports them: Stop-on-a-dime partial vacuum Adding a replication solution to the backend Putting time travel support back in Granted, the 'not good idea' list is pretty exaggerated simply because it's not as easy to find examples of that on the TODO list, since stuff on the TODO list is generally supported. Some of the 'temporal database' items that had been suggested probably fall into the category of 'might be a good idea, but the community hasn't decided that yet'. So maybe we should be limiting SoC projects to stuff that's already on the TODO list.. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)