From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Charles Martin <martin(at)chasm(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: OID rollover? |
Date: | 2000-04-10 02:34:49 |
Message-ID: | 200004100234.WAA08922@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Titus Brown | 2000-04-10 03:16:55 | Minor hack to support LO string searches |
Previous Message | Tatsuo Ishii | 2000-04-10 02:07:36 | Re: A Haunted Database |