From: Euler Taveira de Oliveira <euler@timbira.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-docs@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Volunteer to build a configuration tool
Date: Mon, 18 Jun 2007 23:28:57 -0300
Message-ID: <46773F69.1020003@timbira.com> (raw)
In-Reply-To: <A3AC4FA47DC0B1458C3E5396E685E63302395E53@SAB-DC1.sab.uiuc.edu>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E53@SAB-DC1.sab.uiuc.edu>
Campbell, Lance wrote:
> Next the person would press a button, “generate”, found below the
> questions. The JavaScript HTML page would then generate content for two
> Iframes at the bottom on the page. One Iframe would contain the
> contents of the postgresql.conf file. The postgresql.conf settings
> would be tailored more to the individuals needs than the standard
> default file. The second Iframe would contain the default settings one
> should consider using with their operating system.
>
Man, it's not that easy. :-) Mainly because you will need some database
activity. For example, work_mem, checkpoint_segments, and
checkpoint_timeout depends on the database's dynamic.
Database are not that static so another idea is to build a piece of
software that monitors the database and do the modifications based on
some observations (log, stats, etc). Don't forget that some of these
options need a restart. So maybe your tool just advise the DBA that
he/she could change option X to Y.
Such a tool was proposed later [1] but it's not up to date. :(
[1] http://pgfoundry.org/projects/pgautotune/
--
Euler Taveira de Oliveira
http://www.timbira.com/
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: euler@timbira.com, lance@uiuc.edu, pgsql-docs@postgresql.org
Subject: Re: Volunteer to build a configuration tool
In-Reply-To: <46773F69.1020003@timbira.com>
* 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