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?
Date: Tue, 12 Jun 2007 10:37:16 -0400
Message-ID: <20070612103716.506aa682.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <466EAD5B.4080006@andromeiberica.com>
References: <466EAD5B.4080006@andromeiberica.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, arnaulist@andromeiberica.com
Subject: Re: How much memory PostgreSQL is going to use?
In-Reply-To: <20070612103716.506aa682.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox