Re: Volunteer to build a configuration tool

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-docs(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Volunteer to build a configuration tool
Date: 2007-06-19 02:28:57
Message-ID: 46773F69.1020003@timbira.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-docs pgsql-performance

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/

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Ray Stell 2007-06-19 13:00:19 Re: Volunteer to build a configuration tool
Previous Message Greg Smith 2007-06-19 00:05:23 Re: Volunteer to build a configuration tool

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-06-19 02:56:51 Re: Performance query about large tables, lots of concurrent access
Previous Message Greg Smith 2007-06-19 00:05:23 Re: Volunteer to build a configuration tool