Re: Re: 4 billion record limit?

There are many PostgreSQL supported operating Systems that run on 64-bit
platforms -- virtually every popular Unix except OpenBSD comes to mind :-)

There is something else that many aren't considering. In every application
I've ever written to use any database I use ID numbers of my own making,
always they're integer. 4 billion is the limit on any integer field, not
just the OID so there are limitations everyone should realize when using any
integer for any kind of record identification purposes..

-Mitch

----- Original Message -----
From: "Martin A. Marques" <martin@math.unl.edu.ar>
To: "brad" <brad@kieser.net>
Cc: "Chris Jones" <cjones@rightnowtech.com>; <pgsql-general@postgresql.org>
Sent: Friday, July 28, 2000 6:47 AM
Subject: Re: [GENERAL] Re: 4 billion record limit?


> On Fri, 28 Jul 2000, brad wrote:
>
> > Good point!
> > Okay... 64 bit OIDs will probably just about do the trick!
> > But hey, NEVER underestimate the efficiency of Linux :-)
>
> Never underestimated it!!! Linux for SPARC or ALPHA is 64 bits!!!
> The proble is Intel and the x86 platform!!
>
> Saludos... ;-)
>
>
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -----------------------------------------------------------------
> Martín Marqués email: martin@math.unl.edu.ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
>