Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Lincoln Yeoh
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 3.0.5.32.20010719112306.008f0950@192.228.128.13
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  (Lamar Owen <lamar.owen@wgcr.org>)
Responses Re: Re: OID wraparound (was Re: pg_depend)
List pgsql-hackers
At 06:10 PM 18-07-2001 -0400, Lamar Owen wrote:
>applications.... :-) I guess I'll just need to switch to proper SERIALs and 
>PRIMARY KEYs.  Of course, if I wanted to be stubborn, I'd just use the GUC 
>option to enable OIDs system-wide by default....

The default 32 bit serial primary key isn't immune to roll overs either.

I doubt it'll affect my stuff, but it'll affect others.

Once you talk about storing petabytes or terabytes of data, 32 bits might
not be enough.

Cheerio,
Link.



pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: pg_depend
Next
From: Hiroshi Inoue
Date:
Subject: Re: OID wraparound (was Re: pg_depend)