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

From Tom Lane
Subject Re: OID wraparound: summary and proposal
Date
Msg-id 8173.997200947@sss.pgh.pa.us
Whole thread Raw
In response to Re: OID wraparound: summary and proposal  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: OID wraparound: summary and proposal
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 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.

Well, it'd keep user-space wraparound from affecting the system tables,
but given that the system tables have adequate defenses already (ie,
unique indexes) I'm not sure that there's any point.  It'd not improve
the picture for user-table OID uniqueness by any measurable degree.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Meszaros Attila
Date:
Subject: Recovery error
Next
From: Peter Eisentraut
Date:
Subject: config.guess updated in CVS