Re: PostgreSQL Configuration Tool for Dummies

From: david(at)lang(dot)hm
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 19:11:27
Message-ID: Pine.LNX.4.64.0706191205320.25045@asgard.lang.hm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2007-06-19 19:36:02 Re: Best use of second controller with faster disks?
Previous Message david 2007-06-19 19:02:39 Re: PostgreSQL Configuration Tool for Dummies