Re: Re: 4 billion record limit? - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Re: 4 billion record limit?
Date
Msg-id 008b01bff891$6ed34870$4100000a@doot
Whole thread Raw
In response to Re: Re: 4 billion record limit?  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
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
> -----------------------------------------------------------------
>
>


pgsql-general by date:

Previous
From: Herbert Liechti
Date:
Subject: Re: Async unidirectional replication
Next
From: Andrew Sullivan
Date:
Subject: Re: Re: pg_dump problem