Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 385149FB98D for ; Tue, 12 Jun 2007 11:27:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77043-02 for ; Tue, 12 Jun 2007 11:27:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 86A739FB97B for ; Tue, 12 Jun 2007 11:27:42 -0300 (ADT) Received: by fafnir.androme.com (Postfix, from userid 1003) id 5D887B96CF1; Tue, 12 Jun 2007 16:27:40 +0200 (CEST) Message-ID: <466EAD5B.4080006@andromeiberica.com> Date: Tue, 12 Jun 2007 16:27:39 +0200 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: PostgreSQL Performance Subject: How much memory PostgreSQL is going to use? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/207 X-Sequence-Number: 25240 Hi all, I have a server with 4GB of memory and I'm tweaking the PostgreSQL configuration. This server will be dedicated to run PostgreSQL so I'd like to dedicate as much as possible RAM to it. I have dedicated 1GB to shared_buffers (shared_buffers=131072) but I'm not sure if this will be the maximum memory used by PostgreSQL or additional to this it will take more memory. Because if shared_buffers is the maximum I could raise that value even more. Cheers! -- Arnau