Received: from kci.kciLink.com (kci.kciLink.com [204.117.82.1]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAUIVct51312 for ; Thu, 30 Nov 2000 13:31:38 -0500 (EST) (envelope-from khera@kciLink.com) Received: from yertle.kciLink.com (yertle.kciLink.com [208.184.13.195]) by kci.kciLink.com (Postfix) with ESMTP id F296BC9B9 for ; Thu, 30 Nov 2000 13:31:27 -0500 (EST) Received: from onceler.kciLink.com (onceler.kciLink.com [208.184.13.196]) by yertle.kciLink.com (Postfix) with ESMTP id 905CE2E451 for ; Thu, 30 Nov 2000 13:31:27 -0500 (EST) Received: (from khera@localhost) by onceler.kciLink.com (8.11.1/8.11.1) id eAUIVRj25245; Thu, 30 Nov 2000 13:31:27 -0500 (EST) (envelope-from khera) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14886.40191.455322.734798@onceler.kciLink.com> Date: Thu, 30 Nov 2000 13:31:27 -0500 To: pgsql-general@postgresql.org Subject: Re: Can PostGreSQL handle 100 user database? In-Reply-To: <3A268A5C.91CB7353@wgcr.org> References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> <3A268A5C.91CB7353@wgcr.org> X-Mailer: VM 6.86 under 21.1 (patch 12) "Channel Islands" XEmacs Lucid X-Archive-Number: 200011/997 X-Sequence-Number: 1134 >>>>> "LO" == Lamar Owen writes: LO> The 2GB size limits of ia32 come in to play due to byte addressing LO> (versus word addressing) in ia32 plus the use of signed single register LO> two's-complement integers. LO> But, as always, I reserve the right to be wrong. You are wrong. The file size limit has to do with the data size of your file offset pointer. This is not necessarily a 32 bit quantity on a 32-bit processor. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/