Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6C67A9FB6CA; Mon, 18 Jun 2007 20:35:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 84642-08; Mon, 18 Jun 2007 20:35:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from m.wordtothewise.com (fruitbat.wordtothewise.com [208.187.80.135]) by postgresql.org (Postfix) with ESMTP id 626509FB877; Mon, 18 Jun 2007 20:35:15 -0300 (ADT) Received: from [10.3.2.25] (184.wordtothewise.com [208.187.80.184]) by m.wordtothewise.com (Postfix) with ESMTP id 9572780004; Mon, 18 Jun 2007 16:35:13 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: References: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Steve Atkins Subject: Re: Volunteer to build a configuration tool Date: Mon, 18 Jun 2007 16:35:11 -0700 To: PostgreSQL Performance , PostgreSQL-documentation X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/320 X-Sequence-Number: 25353 On Jun 18, 2007, at 4:09 PM, david@lang.hm wrote: > 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. It doesn't really matter. The implementation is likely to be trivial, and could be independently knocked out by anyone in their favorite language in a few hours. The tricky bits are going to be defining the problem and creating the alogrithm to do the maths from input to output. If that's so, the language or platform the proof-of-concept code is written for isn't that important, as it's likely to be portable to anything else without too much effort. But the tricky bits seem quite tricky (and the first part, defining the problem, is something where someone developing it on their own, without some discussion with other users and devs could easily end up way off in the weeds). Cheers, Steve > > 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... > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend