Date: Tue, 12 Jun 2007 10:37:16 -0400
From: Bill Moran <wmoran@collaborativefusion.com>
To: arnaulist@andromeiberica.com
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: How much memory PostgreSQL is going to use?
Message-Id: <20070612103716.506aa682.wmoran@collaborativefusion.com>
In-Reply-To: <466EAD5B.4080006@andromeiberica.com>
References: <466EAD5B.4080006@andromeiberica.com>
Organization: Collaborative Fusion
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

In response to Arnau <arnaulist@andromeiberica.com>:

> 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.

Individual backend processes will allocate more memory above shared_buffers
for processing individual queries.  See work_mem.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023