Re: PostgreSQL Configuration Tool for Dummies - Mailing list pgsql-performance

From david@lang.hm
Subject Re: PostgreSQL Configuration Tool for Dummies
Date
Msg-id Pine.LNX.4.64.0706191205320.25045@asgard.lang.hm
Whole thread Raw
In response to PostgreSQL Configuration Tool for Dummies  ("Campbell, Lance" <lance@uiuc.edu>)
Responses Re: PostgreSQL Configuration Tool for Dummies  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Tue, 19 Jun 2007, Campbell, Lance wrote:

> Memory
>
> There are many different ways to ask about memory.  Rather than ask a
> series of questions I went with a single question, #2.  If it is better
> to ask about the memory in a series of questions then please give me the
> questions you would ask and why you would ask each of them.  From my
> understanding the primary memory issue as it relates to PostgreSQL is
> "how much memory is available to PostgreSQL".  Remember that this needs
> to be as simple as possible.

there are three catagories of memory useage

1. needed by other software
2. available for postgres
3. needed by the OS

it's not clear if what you are asking is #2 or a combination of #2 and #3

IMHO you should ask for #2 and #3, possibly along the lines of "how much
memory is in the machine that isn't already used by other applications"

David Lang

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies
Next
From: Francisco Reyes
Date:
Subject: Re: Best use of second controller with faster disks?