| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Charles Martin <martin(at)chasm(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: OID rollover? |
| Date: | 2000-04-10 11:54:48 |
| Message-ID: | Pine.GSO.4.02A.10004101348060.8269-100000@Falk.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 9 Apr 2000, Charles Martin wrote:
> What happens to my database when the OID rolls over?
A simple-minded calculation yields that you would have to create about 1
million new (not updated) records every day for more than 10 years to
exhaust the oid space. By the time that becomes a problem we'll all have
64 bit machines in anticipation of Y2038 anyway.
> If the answer is "doom", is there anything I can do about it?
Dump and reload your database. Unless you are actually *using* all of them
(in which case you'd need more than 100 GB to simply store the tuple
control structures), then "doom" is a feature. :)
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Balazs Gyetvai | 2000-04-10 12:29:43 | pg_group table's grolist field |
| Previous Message | iqbal | 2000-04-10 11:10:32 | BLOB datatype |