Re: OID wraparound: summary and proposal - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: OID wraparound: summary and proposal
Date
Msg-id 200108071528.f77FShH14433@candle.pha.pa.us
Whole thread Raw
In response to Re: OID wraparound: summary and proposal  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: OID wraparound: summary and proposal
List pgsql-hackers
> > Based on the discussion so far, here is an attempt to flesh out the
> > details of what to do with OIDs for 7.2:
> > 
> > 1. Add an optional clause "WITH OIDS" or "WITHOUT OIDS" to CREATE TABLE.
> > The default behavior will be WITH OIDS.
> 
> What about having an additional Oid generator which solely serves for
> supplying user tables' per row Oids? It seems relatively easy to
> implement, comparing with 64-bit Oids or Oid-less tables. I assume
> that the Oid wraparound problem is not so serious with user tables.

This is a very interesting idea.  Have two oid counters, one for system
tables and another for user tables.  It isolates problems with oid
wraparound caused by large user tables.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: OID wraparound: summary and proposal
Next
From: Tom Lane
Date:
Subject: Re: OID wraparound: summary and proposal