From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>, "brad" <brad(at)kieser(dot)net> |
Cc: | "Chris Jones" <cjones(at)rightnowtech(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: 4 billion record limit? |
Date: | 2000-07-28 12:43:29 |
Message-ID: | 008b01bff891$6ed34870$4100000a@doot |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
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(at)math(dot)unl(dot)edu(dot)ar>
To: "brad" <brad(at)kieser(dot)net>
Cc: "Chris Jones" <cjones(at)rightnowtech(dot)com>; <pgsql-general(at)postgresql(dot)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(at)math(dot)unl(dot)edu(dot)ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffery Collins | 2000-07-28 12:57:21 | Re: Connection problem under extreme load. |
Previous Message | Herbert Liechti | 2000-07-28 11:36:13 | Re: Async unidirectional replication |
From | Date | Subject | |
---|---|---|---|
Next Message | Keith G. Murphy | 2000-07-28 16:48:10 | Re: Re: 4 billion record limit? |
Previous Message | Herbert Liechti | 2000-07-28 11:36:13 | Re: Async unidirectional replication |