Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B2C6B63270D for ; Mon, 22 Feb 2010 11:05:13 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 52987-04 for ; Mon, 22 Feb 2010 15:04:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.mhsoftware.com (mail.mhsoftware.com [209.169.14.178]) by mail.postgresql.org (Postfix) with ESMTP id 13D79632713 for ; Mon, 22 Feb 2010 11:05:02 -0400 (AST) Received: from emp00 (c-76-120-104-193.hsd1.co.comcast.net [76.120.104.193]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mail.mhsoftware.com (Postfix) with ESMTPSA id 9484E2DD3D for ; Mon, 22 Feb 2010 08:05:00 -0700 (MST) From: "George Sexton" To: Subject: shared_buffers Date: Mon, 22 Feb 2010 08:04:59 -0700 Message-ID: <05ee01cab3d0$67abeb10$3703c130$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acqz0GaRAd+BGE6pQHSj5dIxAIGIoA== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/297 X-Sequence-Number: 37718 I'm reading the docs for 8.4.2, section 18.4.1 Memory. I'm trying to = figure out what reasonable values for my usage would be. The doc says: shared_buffers (integer) Sets the amount of memory the database server uses for shared memory buffers. While circular definitions are always right, I'm kind of looking for = some information like: "PostgreSQL uses shared memory buffers for ...." Could someone please explain what the role of shared buffers is? George Sexton MH Software, Inc. - Home of Connect Daily Web Calendar http://www.mhsoftware.com/ Voice: 303 438 9585 =A0=20