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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-sql by date

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