pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lamar Owen <lamar.owen@wgcr.org>
To: Vivek Khera <khera@kciLink.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
Date: Thu, 30 Nov 2000 13:59:20 -0500
Message-ID: <3A26A388.3BAF89AD@wgcr.org> (raw)
References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com>
	<3A268A5C.91CB7353@wgcr.org>
	<14886.40191.455322.734798@onceler.kciLink.com>

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



view thread (16+ messages)  latest in thread

Message-ID: <3A26A388.3BAF89AD@wgcr.org>
Permalink:  ../3A26A388.3BAF89AD@wgcr.org/
Also on:    postgresql.org/message-id/3A26A388.3BAF89AD@wgcr.org

 · 

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: lamar.owen@wgcr.org, khera@kciLink.com, pgsql-general@postgresql.org
  Subject: Re: Can PostGreSQL handle 100 user database?
  In-Reply-To: <3A26A388.3BAF89AD@wgcr.org>
  References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> <3A268A5C.91CB7353@wgcr.org> <14886.40191.455322.734798@onceler.kciLink.com> <3A26A388.3BAF89AD@wgcr.org>

* 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