Skip site navigation (1) Skip section navigation (2)

Re: How much memory PostgreSQL is going to use?

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How much memory PostgreSQL is going to use?
Date: 2007-06-12 14:37:16
Message-ID: 20070612103716.506aa682.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-performance
In response to Arnau <arnaulist(at)andromeiberica(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2007-06-12 14:59:10
Subject: Re: test / live environment, major performance difference
Previous:From: Steinar H. GundersonDate: 2007-06-12 14:30:33
Subject: Re: test / live environment, major performance difference

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group