Re: Linux max on shared buffers?

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Martin Dillard <martin(at)edusoftinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Linux max on shared buffers?
Date: 2002-07-11 03:32:43
Message-ID: Pine.NEB.4.44.0207111229270.436-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-07-11 03:36:55 Re: Linux max on shared buffers?
Previous Message Curt Sampson 2002-07-11 03:25:40 Re: was there a change in FreeBSD SHM implementation from