From: Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
To: pgsql-students@postgresql.org
Subject: Re: Applying GSoc prosgres and do contribution
Date: Wed, 06 Apr 2011 17:24:50 +0200
Message-ID: <4D9C85C2.1020501@wars-nicht.de> (raw)
In-Reply-To: <BANLkTikvsMj6Gy-rmNZAYhGfYjPNt7STRA@mail.gmail.com>
References: <BANLkTimf-0Rko0uAUW_jR+3y6gkksewDQw@mail.gmail.com>
<BANLkTinibVLPqTu80m733LEh7r9_zrcvEw@mail.gmail.com>
<BANLkTik7GLcsgtweA48bK8bNbZOLpGfYww@mail.gmail.com>
<BANLkTimDDxhU+WbqpXJYSwMaa+atq3CRRw@mail.gmail.com>
<BANLkTikvsMj6Gy-rmNZAYhGfYjPNt7STRA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-students@postgresql.org
Cc: adsmail@wars-nicht.de
Subject: Re: Applying GSoc prosgres and do contribution
In-Reply-To: <4D9C85C2.1020501@wars-nicht.de>
References: <BANLkTimf-0Rko0uAUW_jR+3y6gkksewDQw@mail.gmail.com> <BANLkTinibVLPqTu80m733LEh7r9_zrcvEw@mail.gmail.com> <BANLkTik7GLcsgtweA48bK8bNbZOLpGfYww@mail.gmail.com> <BANLkTimDDxhU+WbqpXJYSwMaa+atq3CRRw@mail.gmail.com> <BANLkTikvsMj6Gy-rmNZAYhGfYjPNt7STRA@mail.gmail.com> <4D9C85C2.1020501@wars-nicht.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox