Re: Linux max on shared buffers? - Mailing list pgsql-general

From Curt Sampson
Subject Re: Linux max on shared buffers?
Date
Msg-id Pine.NEB.4.44.0207111229270.436-100000@angelic.cynic.net
Whole thread Raw
In response to Linux max on shared buffers?  ("Martin Dillard" <martin@edusoftinc.com>)
Responses Re: Linux max on shared buffers?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Wed, 10 Jul 2002, Martin Dillard wrote:

> When I try to allocate 2 GB or more....

If I recall correctly, under normal circumstances a process under
Linux has an address space of only 2 GB. Therefore you will never
be able to allocate more memory than that. I think there's a patch
(maybe from SGI?) that lets you increase this to 3 GB, but at any
rate it's always going to be well under 4 GB, no matter what you
do, unless you move to a 64-bit processor.

But really, as discussed just in the last week on this list, you want to
allocate more like 10 MB or so to postgres' shared memory area. Then the
rest of your memory will be used as buffer cache and you will be happy.
If you want to know why, go back though the archives of this list.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: was there a change in FreeBSD SHM implementation from
Next
From: Bruce Momjian
Date:
Subject: Re: Linux max on shared buffers?