Re: How much memory PostgreSQL is going to use? - Mailing list pgsql-performance

From Bill Moran
Subject Re: How much memory PostgreSQL is going to use?
Date
Msg-id 20070612103716.506aa682.wmoran@collaborativefusion.com
Whole thread Raw
In response to How much memory PostgreSQL is going to use?  (Arnau <arnaulist@andromeiberica.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: test / live environment, major performance difference
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: test / live environment, major performance difference