Re: Applying GSoc prosgres and do contribution

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-students(at)postgresql(dot)org
Subject: Re: Applying GSoc prosgres and do contribution
Date: 2011-04-06 15:24:50
Message-ID: 4D9C85C2.1020501@wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-students


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

In response to

Browse pgsql-students by date

  From Date Subject
Next Message Greg Smith 2011-04-21 23:41:33 Re: Applying GSoc prosgres and do contribution
Previous Message Selena Deckelmann 2011-04-06 13:36:02 Reminder! Proposals due by Friday, April 9 19:00 UTC