From: Alvaro Herrera <alvherre@commandprompt.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: valiouk@yahoo.co.uk, pgsql-docs@postgresql.org, dx k9 <bitsandbytes88@hotmail.com>
Subject: Re: [ADMIN] shared_buffers and shmmax
Date: Tue, 16 Dec 2008 11:43:27 -0300
Message-ID: <20081216144327.GI4741@alvh.no-ip.org> (raw)
In-Reply-To: <200812160313.mBG3DLH09968@momjian.us>
References: <14937.1229387738@sss.pgh.pa.us>
<200812160313.mBG3DLH09968@momjian.us>
Bruce Momjian wrote:
> OK, I never got the change applied because of Alvaro's objection so
> there is nothing to revert. Alvaro said he has an idea for improved
> wording; I do not.
I think we should add a more explicit note, like in the attached patch.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Attachments:note-buffersize.patch (text/x-diff, 845B) download
Index: runtime.sgml
===================================================================
RCS file: /home/alvherre/Code/cvs/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.422
diff -c -p -r1.422 runtime.sgml
*** runtime.sgml 20 Nov 2008 11:48:26 -0000 1.422
--- runtime.sgml 16 Dec 2008 14:40:42 -0000
*************** set semsys:seminfo_semmsl=32
*** 1124,1129 ****
--- 1124,1139 ----
</tbody>
</tgroup>
</table>
+ + <note>+ <para>+ The multipliers for <varname>shared_buffers</> and+ <varname>wal_buffers</> should be the number of buffers, not the+ amount in bytes. To find out the number of shared or wal buffers, divide+ the amount in bytes by <xref linkend="guc-block-size"> and+ <xref linkend="guc-wal-block-size">, respectively.+ </para>+ </note>
</sect2>
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: alvherre@commandprompt.com, bruce@momjian.us, tgl@sss.pgh.pa.us, bitsandbytes88@hotmail.com
Subject: Re: [ADMIN] shared_buffers and shmmax
In-Reply-To: <20081216144327.GI4741@alvh.no-ip.org>
* 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