pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francis Solomon <francis@stellison.co.uk>
To: pgsql-general@postgresql.org
Subject: RE: Can PostGreSQL handle 100 user database?
Date: Thu, 30 Nov 2000 19:39:01 -0000
Message-ID: <NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk> (raw)
In-Reply-To: <Pine.BSF.4.21.0011301347320.323-100000@thelab.hub.org>

Hi,

2Gb file *systems* have been supported forever and a day on Linux. ext2
supports this without batting an eyelid. 2Gb *files* have not been
supported very well or very long on 32-bit systems. Essentially you need
a recent 2.4.0-test kernel version (test7 and up) or a patched 2.2.x
kernel (more likely if you're in a production environment). For more
information, see http://www.suse.de/~aj/linux_lfs.html

2Gb memory is a limitation under x86 (ia32) Linux in current production
kernels (2.2.x).
Again, the new 2.4.0 kernels go one better by using Intel's PAE
(Physical Address Extension) mode on Pentium Pro CPUs and newer. This
raises the available memory on Linux to 64Gb. Of course, 2.4.0-testx
kernels are not production quality, but it's a good taste of what's
imminent.

Hope this helps.

Francis Solomon

>
> 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 ...




view thread (16+ messages)  latest in thread

Message-ID: <NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk>
Permalink:  ../NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk/
Also on:    postgresql.org/message-id/NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: francis@stellison.co.uk, pgsql-general@postgresql.org
  Subject: Re: Can PostGreSQL handle 100 user database?
  In-Reply-To: <NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk>
  References: <Pine.BSF.4.21.0011301347320.323-100000@thelab.hub.org> <NEBBIFFPELJMCJAODNPKEEGGCDAA.francis@stellison.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox