RE: unique row identifier data type exhausted . . . - Mailing list pgsql-general

From Tom Cook
Subject RE: unique row identifier data type exhausted . . .
Date
Msg-id Pine.LNX.4.10.10004270927440.29564-100000@frog.adl.ardec.com.au
Whole thread Raw
In response to RE: unique row identifier data type exhausted . . .  ("Dale Anderson" <danderso@crystalsugar.com>)
List pgsql-general
Alright, alright already! Maybe 64-bit OIDs are sufficient for reasonable
people. My point was that, as soon as you set a limit on something,
someone will find a use for it which pushes that limit.

"640K should be enought for anyone." - William Gates

On Wed, 26 Apr 2000, Dale Anderson wrote:

> Seems to me that 64 bit OIDs is enough for any rational sensible person, and if it's not enough for you, then you
haveway too much time to think about it. 
>
> >>> e99re41@DoCS.UU.SE 04/26/00 08:53AM >>>
> On Wed, 26 Apr 2000, Tom Cook wrote:
>
> > Is this necessarily a good solution? If you use 64-bit OIDs, some joker
> > will just hook up a several-terra-byte disk array to his machine, try to
> > store the location of every molecule in the universe and break it.
>
> That's not going to work anyway. To store information about a molecule you
> need at least one such molecule to hold that state, barring major
> revolutions in storage technology. :-)
>
> > Admittedly, ~2x10^20 is a very large number, but that's what they thought
> > about 2000, also...
>
> A while ago I said that in order to exhaust the oid space you need to add
> 1 million new records a day for more than 10 years. Then someone said, ok,
> what if I have an email service with 1 million users that each get 10
> emails a day. Then you're talking about 1 year. But in order to exhaust 64
> bits, you can have 10^9 users (i.e., everyone), getting two million emails
> a day for 1000 years. That seems pretty safe for as long as I care.
>
> Of course to store all molecules you really need more like 384 bits.
>
> > What I'm saying is, is there a better way of doing this?
>
> Transfinite numbers ;)
>
>
> --
> Peter Eisentraut                  Sernanders v�g 10:115
> peter_e@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden
>
>
>

--
Tom Cook - Software Engineer

"Never criticize a man until you've walked a mile in his shoes; that way,
when you criticize him, you're a mile away and have his shoes."
    - Unknown

LISAcorp - www.lisa.com.au

--------------------------------------------------
38 Greenhill Rd.          Level 3, 228 Pitt Street
Wayville, SA, 5034        Sydney, NSW, 2000

Phone:   +61 8 8272 1555  Phone:   +61 2 9283 0877
Fax:     +61 8 8271 1199  Fax:     +61 2 9283 0866
--------------------------------------------------


pgsql-general by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: storing large amounts of text
Next
From: Tom Cook
Date:
Subject: Re: How to connect using pg_connect function from php3 ?