From: Greg Smith <gsmith@gregsmith.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Overhauling GUCS
Date: Thu, 5 Jun 2008 15:15:14 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0806051452480.27254@westnet.com> (raw)
In-Reply-To: <20080605174209.GL16502@alvh.no-ip.org>
References: <20080604131810.GH65238@decibel.org>
<4846A483.8000001@pse-consulting.de>
<Pine.GSO.4.64.0806041045520.2258@westnet.com>
<29525.1212613052@sss.pgh.pa.us>
<48472E47.7030701@dunslane.net>
<Pine.GSO.4.64.0806042033120.3874@westnet.com>
<20080605162400.GF16502@alvh.no-ip.org>
<48481CBF.6040602@enterprisedb.com>
<48481E3A.4010306@hagander.net>
<Pine.GSO.4.64.0806051321360.27711@westnet.com>
<20080605174209.GL16502@alvh.no-ip.org>
On Thu, 5 Jun 2008, Alvaro Herrera wrote:
> I must say that I am confused by this thread. What's the discussed GUC
> overhaul?
http://wiki.postgresql.org/wiki/GUCS_Overhaul
I drop that URL in every other message in hopes that people might start
commenting on it directly if they see it enough; the fact that you're
confused says I may need to keep that up :(
> (1) Add a lot more comments to each setting
> (2) Add documentation links to each setting
> (3) Move more frequently used settings to the top of the file
> (4) Ship different sample config files
> (5) Create an expert system to suggest tuning
> (6) Other random ideas (XML, settings in database, others?)
>
> To me, there are two ideas that are doable right now, which are (2) and
> (4). (1) seems to be a step backwards in pg_hba.conf experience, and we
> would have to maintain duplicate documentation. (3) seems messy. (5)
> is a lot of work; do we have volunteers? As for (6), the two examples I
> give can be easily dismissed.
> (2) and (4) do not seem necessary to get the config API built.
(1) is in that proposal but is strictly optional as something to put in
the configuration file itself. The idea behind (2) is to enable tool
authors to have an easier way to suggest where to head for more
information. I'd like for it to be trivial for a tool to say "Suggested
value for <x> is <y>; see
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html
for more information". I know what most of the settings I tinker with do,
but even I'd like it to be easier to find the right spot in the manual;
for newbies it's vital. You are correct that (2) isn't strictly necessary
here, but it's valuable and will be easier to wrap into this than to bolt
on later.
(3) (4) (5) and (6) were off-topic diversions.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: gsmith@gregsmith.com, alvherre@commandprompt.com, magnus@hagander.net, heikki@enterprisedb.com
Subject: Re: Overhauling GUCS
In-Reply-To: <Pine.GSO.4.64.0806051452480.27254@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox