Re: [GENERAL] OID rollover?
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 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
[GENERAL] OID rollover?
What happens to my database when the OID rolls over? If the answer is "doom", is there anything I can do about it?
Re: [GENERAL] OID rollover?
What happens to my database when the OID rolls over? If the answer is "doom", is there anything I can do about it? Actually, no one has every reported a roll-over, so I can't say for sure. They are unsigned ints, so it should go past 2 gigs. If it goes past 4 gigs, it rolls to zero again. Having duplicate oids in the same table is really not a crisis, though there could be come oid collision in the system tables that could cause problems. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
