Date: Tue, 12 Aug 2008 15:43:44 -0400 (EDT)
From: Greg Smith <gsmith@gregsmith.com>
To: Bruce Momjian <bruce@momjian.us>
cc: Greg Sabino Mullane <greg@turnstep.com>, pgsql-docs@postgresql.org,
	pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax
In-Reply-To: <200808121748.m7CHmfX26268@momjian.us>
Message-ID: <Pine.GSO.4.64.0808121534260.22776@westnet.com>
References: <200808121748.m7CHmfX26268@momjian.us>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Tue, 12 Aug 2008, Bruce Momjian wrote:

>> There's already some changes needed in this area needed to execute the
>> full GUC cleanup/wizard plan that's being worked on.  The pg_settings view
>> really should show the value both as the user input it and as it's stored
>> internally for cases like these, which lowers the confusion here a bit
>> even without going so far as converting everything to bytes.
>
> Is this a TODO?

I don't think you need yet another TODO for every detail, the existing 
TODO "Add external tool to auto-tune some postgresql.conf parameters" has 
to squash a bunch of issues in this area.  This particular issue Greg 
raised will already be improved significantly if executing the larger 
project plan at http://wiki.postgresql.org/wiki/GUCS_Overhaul

This week Robert Treat and I have been doing a lot of work on "Problem #1" 
there, "Most people have no idea how to set [GUCs]" which I know some 
people wanted to see a more formal document for before mucking with any of 
the code.  I'll have something to announce there shortly.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD