From: Greg Smith <gsmith@gregsmith.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-docs@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax
Date: Tue, 12 Aug 2008 15:43:44 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0808121534260.22776@westnet.com> (raw)
In-Reply-To: <200808121748.m7CHmfX26268@momjian.us>
References: <200808121748.m7CHmfX26268@momjian.us>
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
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-admin@postgresql.org
Cc: gsmith@gregsmith.com, bruce@momjian.us, greg@turnstep.com, pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax
In-Reply-To: <Pine.GSO.4.64.0808121534260.22776@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