Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 68F501337C0C for ; Fri, 11 Mar 2011 12:03:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 32729-03-4 for ; Fri, 11 Mar 2011 16:03:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 61FE81337BF9 for ; Fri, 11 Mar 2011 12:03:23 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p2BG3PJ01892; Fri, 11 Mar 2011 11:03:25 -0500 (EST) From: Bruce Momjian Message-Id: <201103111603.p2BG3PJ01892@momjian.us> Subject: Re: explaining "context" column of pg_settings In-Reply-To: <17754.1292544709@sss.pgh.pa.us> To: Tom Lane Date: Fri, 11 Mar 2011 11:03:25 -0500 (EST) CC: Josh Kupershmidt , pgsql-docs X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/76 X-Sequence-Number: 6509 I am unclear where to put this as well so I suggest we just put it in catalogs.sgml and be done with it. --------------------------------------------------------------------------- Tom Lane wrote: > Josh Kupershmidt writes: > > The six different kinds of contexts in the pg_settings system view > > aren't terribly well documented. The current doc page says only: > > "Context required to set the parameter's value". A search through the > > archives turned up only a brief explanation[1] of what "postmaster" > > means for this setting. The recent book "PostgreSQL 9.0 High > > Performance"[2] complains "The context field isn't documented very > > well in the official manual." > > > I've put together a patch to help document these values based on the > > comments in guc.h, the explanations in [2], and my own understanding. > > My crude explanations could probably use some further wordsmithing and > > check for accuracy :-) > > I did some work on this patch and attach an updated version. I'm not > however convinced that it's a good idea to bury this material in > catalogs.sgml --- I think few people ever read that chapter. Shouldn't > we put this into config.sgml instead, somewhere in section 18.1? > > > I avoided just copy-pasting from guc.h, particulary because some of > > the explanations struck me as confusing or incorrect. > > Well, your replacement explanations seemed even less correct ;-). > Also, I think what the text needs to emphasize is *how* to change > each setting type, so that prompted some of my editing. > > regards, tom lane > Content-Description: guc-context-docs-2.patch > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +