Re: OID wraparound (was Re: pg_depend)

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: OID wraparound (was Re: pg_depend)
Date: 2001-07-19 03:23:06
Message-ID: 3.0.5.32.20010719112306.008f0950@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-07-19 03:54:30 Re: OID wraparound (was Re: pg_depend)
Previous Message Horst Herb 2001-07-19 03:03:28 Re: OID wraparound (was Re: pg_depend)