Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9634B2E00BA for ; Wed, 4 Jun 2008 21:08:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86522-01-6 for ; Wed, 4 Jun 2008 21:07:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by developer.postgresql.org (Postfix) with ESMTP id A6CF92E007E for ; Wed, 4 Jun 2008 21:03:27 -0300 (ADT) Received: from pse.dyndns.org (p548F1E6D.dip0.t-ipconnect.de [84.143.30.109]) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis) id 0MKwh2-1K42wo2o7L-00048u; Thu, 05 Jun 2008 02:03:19 +0200 Received: from [84.143.30.109] (helo=[192.168.0.100]) by pse.dyndns.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1K42wn-0001qZ-Db; Thu, 05 Jun 2008 02:03:17 +0200 Message-ID: <48472D26.8040408@pse-consulting.de> Date: Thu, 05 Jun 2008 02:02:46 +0200 From: Andreas Pflug User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Tom Lane CC: pgsql-hackers@postgresql.org Subject: Re: Overhauling GUCS References: <48409D1E.3070208@agliodbs.com> <200806010032.53337.peter_e@gmx.net> <17932.1212415926@sss.pgh.pa.us> <20080604131810.GH65238@decibel.org> <4846A483.8000001@pse-consulting.de> <29525.1212613052@sss.pgh.pa.us> In-Reply-To: <29525.1212613052@sss.pgh.pa.us> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX18B0uIOJfbKdBR8Z+M4sU9UjYjeUuSX4yIb2lX /j/u1u+5yBu00CVsniMEzqOU8iHhwn8nBzxAaB6riQxbbxPW6l Uo+/5wfRNEHhBYTjoahIA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/193 X-Sequence-Number: 119306 Tom Lane wrote: > > * Can we present the config options in a more helpful way (this is 99% > a documentation problem, not a code problem)? > > * Can we build a "configuration wizard" to tell newbies what settings > they need to tweak? It's certainly one thing to create an initial postgresql.conf from scratch after some inquiry, but a different level of problems to deal with when offering to change the settings. IMHO initial creation isn't enough, users will feel even more left alone if there are no tools helping them further. I guess most users will start tweaking after the server is already running for a while, with some config already in place. That's when file format and/or APIs come into play. Preserving comments and/or using them in a wizard isn't too easy with the current format. Regards, Andreas