Skip site navigation (1) Skip section navigation (2)

Re: Can PostGreSQL handle 100 user database?

From: Bruce Guenter <bruceg(at)em(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can PostGreSQL handle 100 user database?
Date: 2000-11-30 18:51:19
Message-ID: 20001130125119.A32028@em.ca (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
On Thu, Nov 30, 2000 at 01:48:43PM -0400, The Hermit Hacker wrote:
> Note that this is a Linux limitation ... and even then, I'm not quite sure
> how accurate that is anymore ... the *BSDs have supported >2gb file
> systems for ages now, and, since IBM supports Linux, I'd be shocked if
> there was a 2GB limit on memory, considering alot of IBMs servers support
> up to 4 or 8GB of RAM ...

Correct.  With the 36-bit PAE extensions on PII and above CPUs, Linux
supports up to the full 64GB of physical RAM.  Individual processes are
limited to either 2GB or 3GB (or 3.5GB), depending on the kernel compile
option as to the division point between kernel and user memory.  Linux
also supports >2GB files (the kernel is limited to 2TB IIRC -- 2^32 512
byte blocks).

Of course, on a 64-bit CPU, all these limitations are off, which really
makes them the platform of choice for heavy data manipulation (I/O).
-- 
Bruce Guenter <bruceg(at)em(dot)ca>                       http://em.ca/~bruceg/

In response to

pgsql-sql by date

Next:From: Adam LangDate: 2000-11-30 18:57:32
Subject: Re: Can PostGreSQL handle 100 user database?
Previous:From: Vivek KheraDate: 2000-11-30 18:31:27
Subject: Re: Can PostGreSQL handle 100 user database?

pgsql-general by date

Next:From: Adam LangDate: 2000-11-30 18:57:32
Subject: Re: Can PostGreSQL handle 100 user database?
Previous:From: Adam LangDate: 2000-11-30 18:44:34
Subject: Re: Can PostGreSQL handle 100 user database - more info

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group