Re: memory - Mailing list pgsql-general

From Curt Sampson
Subject Re: memory
Date
Msg-id Pine.NEB.4.44.0207181124480.681-100000@angelic.cynic.net
Whole thread Raw
In response to Re: memory  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
On Tue, 16 Jul 2002, Andrew Sullivan wrote:

> Any 32-bit x86-based system is going to have some kind of evil hack
> lurking around the 4 Gig mark.  It's just an inherent limitation of a
> 32-bit address space.

Well, it's going to be well under 4 gig for Unix; 2 gig or 3 gig is more
typical, since part of every process' address space is dedicated to
kernel use.

However, when it comes to postgres you're not likely to see any evil
hacks unless you want to dedicated more than a couple of gig to
postgres' shared memory buffers. The OS's cached disk blocks need not
all be mapped at the same time, and each process has a separate address
space, so the total memory used by cached disk blocks and all of the
processes in the system can be well over 4 GB without any problems at all.

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: Darren Ferguson
Date:
Subject: Re: DELETE FROM error message
Next
From: Curt Sampson
Date:
Subject: Re: OIDs (Or: another RTFM question?)