From: | "Andrew Snow" <als(at)fl(dot)net(dot)au> |
---|---|
To: | "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: unique row identifier data type exhausted . . . |
Date: | 2000-04-23 03:19:36 |
Message-ID: | NHEALMDKDACEIPBNOOOCEEKICCAA.als@fl.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> It feels like there should be some *really* obvious answer to this
> question, and I'll find myself whacking my forehead in self-abasement
> and out of sheer relief to have found the answer to a problem that
> should not have bothered me in the first place since the answer is too
> self-evident . . . however, it is bothering me: what happens if the data
> type that you've chosen to uniquely identify a row is exhausted? If, for
> instance you use int4 and you've had your couple billion deletes and
> inserts on the table and the next nextval('seq') . . . well, what
> exactly happens and how do they do it? Admittedly, 10^9 is a big number
> but it is far from out of the question that you'd reach it on a really
> busy database (can't think of a real-world example but that ought to be
> a moot point), not to mention oids since they are unique across an
> entire database.
I am curious to know how difficult it would be (if at all) to change the
type that oid represents, to a 64 bit number. C'mon guys, this isn't the 90s
any more!
- Andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Jurgen Defurne | 2000-04-23 04:28:45 | Re: unique row identifier data type exhausted . . . |
Previous Message | Brett W. McCoy | 2000-04-22 22:59:08 | Re: storing large amounts of text |