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 eAUKRGF04814 for ; Thu, 30 Nov 2000 15:27:17 -0500 (EST) (envelope-from lamar.owen@wgcr.org) Received: from www.wgcr.org (IDENT:root@www.wgcr.org [206.74.232.194]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id PAA94265 for ; Thu, 30 Nov 2000 15:06:41 GMT (envelope-from lamar.owen@wgcr.org) Received: from wgcr.org ([10.1.2.1]) by www.wgcr.org (8.9.3/8.9.3/WGCR) with ESMTP id NAA11325; Thu, 30 Nov 2000 13:59:34 -0500 Message-ID: <3A26A388.3BAF89AD@wgcr.org> Date: Thu, 30 Nov 2000 13:59:20 -0500 From: Lamar Owen X-Mailer: Mozilla 4.73 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: Vivek Khera CC: pgsql-general@postgresql.org Subject: Re: Can PostGreSQL handle 100 user database? References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> <3A268A5C.91CB7353@wgcr.org> <14886.40191.455322.734798@onceler.kciLink.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/1000 X-Sequence-Number: 1137 Vivek Khera wrote: > 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. If the file offset pointer is a signed integer, then it holds. That is an OS specific issue as to the type of the pointer. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11