Re: [HACKERS] [ADMIN] shared_buffers and shmmax

From: Decibel! <decibel(at)decibel(dot)org>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-docs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax
Date: 2008-08-22 05:49:23
Message-ID: DC2E01D0-D702-4BB7-99AB-E6BA2900C87A@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-hackers

On Aug 12, 2008, at 2:43 PM, Greg Smith wrote:
> 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

Yeah, but OTOH it's not clear at all when we might see such a tool,
while clarifying this stuff would help people immediately... I think
a TODO would be good to make sure this doesn't fall through the cracks.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mathias Stjernström 2008-08-22 08:13:50 Re: Ordering not acting right.
Previous Message kumar, Anand (Anand) 2008-08-22 04:57:08 ssl support in XA Datasource

Browse pgsql-docs by date

  From Date Subject
Next Message Decibel! 2008-08-22 05:50:00 Re: pg_standby supported versions
Previous Message Bruce Momjian 2008-08-18 14:31:44 Re: TODO build rule

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-08-22 06:23:01 Re: Proposal: new border setting in psql
Previous Message Tatsuhito Kasahara 2008-08-22 05:27:35 Re: About a message when "pg_ctl -w start" failed