Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2543764FD6D for ; Mon, 15 Dec 2008 19:23:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75016-05 for ; Mon, 15 Dec 2008 19:23:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 7F1ED64FCBE for ; Mon, 15 Dec 2008 19:23:04 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id mBFNN3Y25121; Mon, 15 Dec 2008 18:23:03 -0500 (EST) From: Bruce Momjian Message-Id: <200812152323.mBFNN3Y25121@momjian.us> Subject: Re: [ADMIN] shared_buffers and shmmax In-Reply-To: <28167.1216737959@sss.pgh.pa.us> To: Tom Lane Date: Mon, 15 Dec 2008 18:23:02 -0500 (EST) CC: valiouk@yahoo.co.uk, pgsql-docs@postgresql.org, dx k9 X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ELM1229383382-20708-1_" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/5 X-Sequence-Number: 5012 --ELM1229383382-20708-1_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" Tom Lane wrote: > [ redirecting to pgsql-docs ] > > Valentin Bogdanov writes: > >> From: dx k9 > >> I'm trying to understand what the documentation means > >> by bytes per increment, what is the increment supposed to > >> be bytes, MB, or Kb. > > > shared_buffers is in disk block size, typically 8K, at least that's what it is on Linux platforms. shmmax is quite simply in bytes. > > 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? I have updated the table title to be clearer. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + --ELM1229383382-20708-1_ Content-Transfer-Encoding: 7bit Content-Type: text/x-diff Content-Disposition: inline; filename="/rtmp/diff" Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.422 diff -c -c -r1.422 runtime.sgml *** doc/src/sgml/runtime.sgml 20 Nov 2008 11:48:26 -0000 1.422 --- doc/src/sgml/runtime.sgml 15 Dec 2008 23:22:24 -0000 *************** *** 1087,1093 **** Name ! Approximate multiplier (bytes per increment) as of 8.3 --- 1087,1093 ---- Name ! Additional bytes per object, as of 8.3 *************** *** 1119,1125 **** Fixed space requirements ! 770 kB --- 1119,1125 ---- Fixed space requirements ! 770 k --ELM1229383382-20708-1_--