Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAUKRRF04943 for ; Thu, 30 Nov 2000 15:27:28 -0500 (EST) (envelope-from bruceg@em.ca) Received: from bruce-guenter.dyndns.org (hsregn1-22.sk.sympatico.ca [142.165.128.22]) by thor.tht.net (8.9.3/8.9.3) with SMTP id PAA94497 for ; Thu, 30 Nov 2000 15:13:33 GMT (envelope-from bruceg@em.ca) Received: (qmail 32090 invoked by uid 500); 30 Nov 2000 18:51:19 -0000 Date: Thu, 30 Nov 2000 12:51:19 -0600 From: Bruce Guenter To: pgsql-general@postgresql.org Subject: Re: Can PostGreSQL handle 100 user database? Message-ID: <20001130125119.A32028@em.ca> Mail-Followup-To: pgsql-general@postgresql.org References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-md5; protocol="application/pgp-signature"; boundary="x+6KMIRAuhnl3hBn" Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: ; from scrappy@hub.org on Thu, Nov 30, 2000 at 01:48:43PM -0400 X-Archive-Number: 200011/1001 X-Sequence-Number: 1140 --x+6KMIRAuhnl3hBn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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). --=20 Bruce Guenter http://em.ca/~bruceg/ --x+6KMIRAuhnl3hBn Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6JqGn6W+y3GmZgOgRAtkCAKCjeNp0c1TmkeRoNG7IOu4WpodtMQCgqkQg mLPaOgfiGGPEW7pzgQfVVvw= =8XRC -----END PGP SIGNATURE----- --x+6KMIRAuhnl3hBn--