Subject: Re: [DOCS] [ADMIN] shared_buffers and shmmax
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org
In-Reply-To: <3bd4182ebf79bc4a171f08d03d2edb2f@biglumber.com>
References: <3bd4182ebf79bc4a171f08d03d2edb2f@biglumber.com>
Content-Type: text/plain
Organization: Command Prompt, Inc.
Date: Thu, 24 Jul 2008 11:02:39 -0700
Message-Id: <1216922559.6858.56.camel@jd-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Thu, 2008-07-24 at 17:54 +0000, Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> NotDashEscaped: You need GnuPG to verify this message
> 
> 
> >> shared_buffers is in disk block size, typically 8K
> 
> > The table the OP is looking at (table 17.2 in the 8.3 docs) predates
> > the ability to specify shared_buffers in KB or MB instead of
> > number-of-buffers.  I agree it's not entirely obvious that what it
> > means is "multiply your setting in KB/MB by 8400/8192".  Anybody have
> > an idea how to clarify things?
> 
> Bite the bullet and start showing the buffer settings as a pure number of bytes
> everywhere, and get rid of the confusing '8kB' unit in pg_settings? 

+1

We have helper functions like pg_size_pretty() to resolve the other
issues.

Joshua D. Drake

-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate