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 eAUKR6F04617 for ; Thu, 30 Nov 2000 15:27:06 -0500 (EST) (envelope-from francis@stellison.co.uk) Received: from smtp.stellison.co.uk ([212.56.66.225]) by thor.tht.net (8.9.3/8.9.3) with SMTP id PAA95047 for ; Thu, 30 Nov 2000 15:40:09 GMT (envelope-from francis@stellison.co.uk) Received: (qmail 4238 invoked from network); 30 Nov 2000 20:34:31 -0000 Received: from unknown (HELO neo) (unknown) by unknown with SMTP; 30 Nov 2000 20:34:31 -0000 From: "Francis Solomon" To: Subject: RE: Can PostGreSQL handle 100 user database? Date: Thu, 30 Nov 2000 19:39:01 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-reply-to: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200011/1004 X-Sequence-Number: 1148 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 ...