Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] [ADMIN] shared_buffers and shmmax

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: 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-12 19:43:44
Message-ID: Pine.GSO.4.64.0808121534260.22776@westnet.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-docspgsql-hackers
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

pgsql-docs by date

Next:From: Mark KirkwoodDate: 2008-08-13 09:59:26
Subject: pg_standby supported versions
Previous:From: Bruce MomjianDate: 2008-08-12 17:48:41
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-08-12 19:46:42
Subject: Re: SeqScan costs
Previous:From: Bruce MomjianDate: 2008-08-12 19:42:36
Subject: Re: Plugin system like Firefox

pgsql-admin by date

Next:From: Dey, SutapaDate: 2008-08-13 04:30:15
Subject: URGENT HELP NEEDED: To enable pgsql support in HP-UX 11.23 Itanium
Previous:From: Bruce MomjianDate: 2008-08-12 17:48:41
Subject: Re: [HACKERS] [ADMIN] shared_buffers and shmmax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group