Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL and memory usage - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL and memory usage
Date
Msg-id 9594.1041910222@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL and memory usage  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
Tree view 
"Dann Corbit" <DCorbit@connx.com> writes:
> I have a machine with 4 CPU's and 2 gigabytes of physical ram.
> I would like to get PostgreSQL to use as much memory as possible.  I
> can't seem to get PostgreSQL to use more than 100 megabytes or so.

You should not assume that more is necessarily better.

In many practical situations, it's better to leave the majority of RAM
free for kernel disk caching.

            regards, tom lane

pgsql-general by date:

Previous
From: "Boget, Chris"
Date:
Subject: Timestamp
Next
From: "Dann Corbit"
Date:
Subject: Re: PostgreSQL and memory usage