pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francisco Reyes <lists@stringsutils.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@postgreSQL.org
Cc: bitsandbytes88@hotmail.com
Cc: valiouk@yahoo.co.uk
Subject: Re: [ADMIN] shared_buffers and shmmax
Date: Tue, 22 Jul 2008 15:30:21 -0400
Message-ID: <7262a9b6ab4a76eab29fc9d94226baec@stringsutils.com> (raw)
In-Reply-To: <28167.1216737959@sss.pgh.pa.us>
References: <818191.79570.qm@web25804.mail.ukl.yahoo.com>
	<28167.1216737959@sss.pgh.pa.us>

On 10:45 am 07/22/08 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> [ redirecting to pgsql-docs ]
> 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?


Perhaps changing the table title?
Table 17-2. Configuration parameters affecting PostgreSQL's shared memory
usage when not using a size modified.

Alternatively, below the table we could have clarifications such as:
Previously, it was not possible to indicate a size modified such as M for
Megabytes. As of version X.Y, Postgresql allows to use M, for MB, GB for GB
and more... See.... for all values.

When not using one of the new modifiers the space used would be the number
you enter times the constant on the right side of the table.
For example using 100 shared_buffers would be 100 x 8400  = 840,000 bytes.




view thread (28+ messages)  latest in thread

Message-ID: <7262a9b6ab4a76eab29fc9d94226baec@stringsutils.com>
Permalink:  ../7262a9b6ab4a76eab29fc9d94226baec@stringsutils.com/
Also on:    postgresql.org/message-id/7262a9b6ab4a76eab29fc9d94226baec@stringsutils.com

 · 

reply

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: lists@stringsutils.com, tgl@sss.pgh.pa.us, pgsql-docs@postgreSQL.org, bitsandbytes88@hotmail.com, valiouk@yahoo.co.uk
  Subject: Re: [ADMIN] shared_buffers and shmmax
  In-Reply-To: <7262a9b6ab4a76eab29fc9d94226baec@stringsutils.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