Skip site navigation (1) Skip section navigation (2)

RE: unique row identifier data type exhausted . . .

From: Tom Cook <tcook(at)lisa(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: RE: unique row identifier data type exhausted . . .
Date: 2000-04-26 23:59:40
Message-ID: Pine.LNX.4.10.10004270927440.29564-100000@frog.adl.ardec.com.au (view raw or flat)
Thread:
Lists: 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 have way too much time to think about it.
> 
> >>> e99re41(at)DoCS(dot)UU(dot)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 vg 10:115
> peter_e(at)gmx(dot)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
--------------------------------------------------


In response to

pgsql-general by date

Next:From: Tom CookDate: 2000-04-27 00:04:10
Subject: Re: How to connect using pg_connect function from php3 ?
Previous:From: Jan WieckDate: 2000-04-26 23:27:12
Subject: Re: storing large amounts of text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group