Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1DB231337D27 for ; Wed, 6 Apr 2011 12:29:10 -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 92433-05-4 for ; Wed, 6 Apr 2011 15:29:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fermium.wars-nicht.de (fermium.wars-nicht.de [78.46.103.110]) by mail.postgresql.org (Postfix) with ESMTP id C88031337CE4 for ; Wed, 6 Apr 2011 12:25:03 -0300 (ADT) Received: from platin.wars-nicht.de (unknown [92.117.217.23]) by fermium.wars-nicht.de (Postfix) with ESMTPSA id 2B67E1A4006C for ; Wed, 6 Apr 2011 17:25:01 +0200 (CEST) Received: from [127.0.0.1] (localhost.localdomain [127.0.0.1]) by platin.wars-nicht.de (Postfix) with ESMTP id E4972B9203A for ; Wed, 6 Apr 2011 17:24:50 +0200 (CEST) Message-ID: <4D9C85C2.1020501@wars-nicht.de> Date: Wed, 06 Apr 2011 17:24:50 +0200 From: Andreas 'ads' Scherbaum User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.14) Gecko/20110223 Lightning/1.0b2 Thunderbird/3.1.8 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=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/13 X-Sequence-Number: 200 Hi, Am 05.04.2011 17:13, schrieb HuangQi: > > 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? Well, the idea behind this script is to auto-tune some of the postgresql.conf settings based on the actual hardware and of course based on the expected workload. There are two different jobs to do: - Determine the current hardware confiuguration (number and speed of cpu's, ram size, i/o, number of disks, network, ...) - Ask the user - or even better, trace the database - about the expected workload (reads, writes, mixed workload, oltp, data warehouse, number of concurrent connections and queries, used ram for queries and cache, and so on) I think, Perl or Python is a choice of the author, whatever he knows best. Of course, it would be helpful, if such a script (or collection of scripts) would use the same scripting language than all the current scripts in the PostgreSQL source. Hope, this helps -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project