Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 78FA89FB7E6; Mon, 18 Jun 2007 20:00:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 90338-05; Mon, 18 Jun 2007 20:00:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 1CA099FB937; Mon, 18 Jun 2007 20:00:11 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id l5IN0BQU021867; Mon, 18 Jun 2007 19:00:11 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id l5IN0BX5021863; Mon, 18 Jun 2007 19:00:11 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Mon, 18 Jun 2007 19:00:11 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: "Campbell, Lance" cc: pgsql-docs@postgresql.org, pgsql-performance@postgresql.org Subject: Re: Volunteer to build a configuration tool In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/318 X-Sequence-Number: 25351 On Mon, 18 Jun 2007, Campbell, Lance wrote: > 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. I'd toyed with making a Javascript based tool for this but concluded it wasn't ever going to be robust enough for my purposes. It wouldn't hurt to have it around through, as almost anything is an improvement over the current state of affairs for new users. As far as prior art goes here, there was an ambitious tool driven by Josh Berkus called Configurator that tried to address this need but never got off the ground, you might want to swipe ideas from it. See http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/configurator/configurator/ for some documents/code and http://pgfoundry.org/docman/index.php?group_id=1000106 for a handy Open-Office spreadsheet. If you want this to take off as a project, make sure you can release the code under a free software license compatible with the PostgreSQL project, so others can contribute to it and it can be assimilated by the core project if it proves helpful. I know I wouldn't spend a minute working on this if that's not the case. I'd suggest you try and get the basic look fleshed out with some reasonable values for the parameters, then release the source and let other people nail down the parts you're missing. Don't get stressed about making sure you have a good value to set for everything before releasing a beta, it's a lot easier for others to come in and help fix a couple of parameters once the basic framework is in place. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD