X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 970B932A0F8 for ; Wed, 6 Oct 2004 23:28:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73209-05 for ; Wed, 6 Oct 2004 22:28:09 +0000 (GMT) Received: from mail.refractions.net (mail.refractions.net [24.68.236.214]) by svr1.postgresql.org (Postfix) with ESMTP id DED0032A0D0 for ; Wed, 6 Oct 2004 23:28:10 +0100 (BST) Received: from lion.animals (lion [192.168.50.200]) by mail.refractions.net (Postfix) with ESMTP id E59902BEC6; Wed, 6 Oct 2004 15:28:09 -0700 (PDT) Received: by lion.animals (Postfix, from userid 88) id 7400AE3BA; Wed, 6 Oct 2004 15:28:09 -0700 (PDT) Received: from [192.168.50.11] (unknown [192.168.50.11]) by lion.animals (Postfix) with ESMTP id 13D26E3B7; Wed, 6 Oct 2004 15:28:08 -0700 (PDT) Message-ID: <41647127.3060407@refractions.net> Date: Wed, 06 Oct 2004 15:26:47 -0700 From: Paul Ramsey User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Doug Y Cc: pgsql-performance@postgresql.org Subject: Re: The never ending quest for clarity on shared_buffers References: <6.1.2.0.2.20041006152747.033bcd50@pop.traderonline.com> In-Reply-To: <6.1.2.0.2.20041006152747.033bcd50@pop.traderonline.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/72 X-Sequence-Number: 8548 Doug Y wrote: > For idle persistent connections, do each of them allocate the memory > specified by this setting (shared_buffers * 8k), or is it one pool used > by all the connection (which seems the logical conclusion based on the > name SHARED_buffers)? Personally I'm more inclined to think the latter > choice, but I've seen references that alluded to both cases, but never a > definitive answer. The shared_buffers are shared (go figure) :). It is all one pool shared by all connections. The sort_mem and vacuum_mem are *per*connection* however, so when allocating that size you have to take into account your expected number of concurrent connections. Paul