Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 628FC9FB680; Mon, 18 Jun 2007 20:09:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43092-09; Mon, 18 Jun 2007 20:09:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from bifrost.lang.hm (dsl081-033-126.lax1.dsl.speakeasy.net [64.81.33.126]) by postgresql.org (Postfix) with ESMTP id 96D8D9FA425; Mon, 18 Jun 2007 20:09:37 -0300 (ADT) Received: from asgard (asgard.lang.hm [10.0.0.100]) by bifrost.lang.hm (8.13.4/8.13.4/Debian-3) with ESMTP id l5IN9ZhL016128; Mon, 18 Jun 2007 16:09:35 -0700 Date: Mon, 18 Jun 2007 16:09:34 -0700 (PDT) From: david@lang.hm X-X-Sender: dlang@asgard.lang.hm 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-Spam-Status: No, hits=0.309 tagged_above=0 required=5 tests=AWL=-0.602, BAYES_40=-0.185, FORGED_RCVD_HELO=0.135, NO_REAL_NAME=0.961 X-Spam-Level: X-Archive-Number: 200706/319 X-Sequence-Number: 25352 one thing to point out to people about this idea is that nothing says that this page needs to be served via a webserver. If all the calculations are done in javascript this could be a local file that you open with a browser. do any of the text-mode browsers implement javascript? if so then you have an answer even for the deeply buried isolated headless servers. David Lang On Mon, 18 Jun 2007, Campbell, Lance wrote: > > I am a Java Software architect, DBA, and project manager for the > University of Illinois, Department of Web Services. We use PostgreSQL > to serve about 2 million pages of dynamic content a month; everything > from calendars, surveys, forms, discussion boards, RSS feeds, etc. I am > really impressed with this tool. > > > > The only major problem area I have found where PostgreSQL is really > lacking is in "what should my initial configuration settings be?" I > realize that there are many elements that can impact a DBA's specific > database settings but it would be nice to have a "configuration tool" > that would get someone up and running better in the beginning. > > > > This is my idea: > > > > A JavaScript HTML page that would have some basic questions at the top: > > 1) How much memory do you have? > > 2) How many connections will be made to the database? > > 3) What operating system do you use? > > 4) Etc...