Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id CE70B1337BF3 for ; Thu, 21 Apr 2011 20:40:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 35515-09 for ; Thu, 21 Apr 2011 23:40:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by mail.postgresql.org (Postfix) with ESMTP id 127A91337BEF for ; Thu, 21 Apr 2011 20:40:41 -0300 (ADT) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0LzpYp-1Pivlr2DeV-014OLY; Fri, 22 Apr 2011 01:40:40 +0200 Message-ID: <4DB0C0AD.4000703@2ndQuadrant.com> Date: Thu, 21 Apr 2011 19:41:33 -0400 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20110307 Icedove/3.0.11 MIME-Version: 1.0 To: pgsql-students@postgresql.org Subject: Re: Applying GSoc prosgres and do contribution References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:7C5+vBV7kw0B5O3DVwpJemeNwyakMd7DndnydlJzux1 QXCcMsfOBHw6tRD3xiUcsqGmXc8aMmvJD3XK1+DcEVdgAdQgbT z9XwgOfYh8Cle2EjRL1cB6s98ZdWqMePdXwiewUoFwJJo48Zw8 tgTHGZKx2Z+XhSNV15d5HshMZPbx3drMk6mTnnWvq1K/uVZca5 UKgX1C3cEjsTmIbitSH1ChTb8B6W6bnKOi/xt5Uqb8= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201104/14 X-Sequence-Number: 201 On 04/05/2011 11:23 AM, Selena Deckelmann wrote: > On Tue, Apr 5, 2011 at 8:13 AM, HuangQi wrote: > >> Hi, >> >> I was looking at the Finish JSON data type work, but as I check the achieved >> mail. It seems it already has 4 proposals. So I don't know whether it still >> needs help. >> And I'm interested in the Improve the auto-configuration script (Python or >> Perl). But I don't know much about Python or Perl yet. How could I get the >> further idea of what this auto-configuration script is about? >> > Here's the source code: > > https://github.com/gregs1104/pgtune > > Have a look at that. I am not sure what the current list of TODOs is > for it Documented in https://github.com/gregs1104/pgtune/blob/master/TODO ; a little cryptic, but in several cases the relevant code has comments about the details too. It's in Python because all previous attempts to do this were in Perl and never got to where they worked. I'm not going to claim those two facts are correlated, but now that pgtune is shipping in Debian I have some satisfaction that I didn't make a completely wrong choice. The remaining work is all easy, but extremely boring and provides little satisfaction for the time spent on it. Completely feasible for a student project, perfect way to get your hands dirty doing what real development requires. But since it's not the sort of sexy auto-tuning work people think it is I don't expect to ever get anyone interested in it. What's left is boring old-people coding; I did all the fun stuff already. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books