OIDs overflow
By when, is serial and the OIDs expected to be converted to int8 or even int6 for that matter rather than int4.
Also, what all transactions consume OIDs. Is it true that every update, select and delete also consume OIDs or only objects created (including tables, view, rows, etc.) consume them. Even if all other transactions consume OIDs, isnt that a waste... Shouldnt OIDs be used simply to identify the objects.
Kapil
On Wed, 9 May 2001, Kapil Tilwani wrote:
By when, is serial and the OIDs expected to be converted to int8 or even int6 for that matter rather than int4.
Also, what all transactions consume OIDs. Is it true that every update, select and delete also consume OIDs or
only objects created (including tables, view, rows, etc.) consume them.
Even if all other transactions consume OIDs, isnt that a waste...
Shouldnt OIDs be used simply to identify the objects.
Oids are only used when a new object is created. Transactions are
enumerated with xids. Oid overflow is not a very big problem but
with xid overflow IMHO bad things may happen.
- Einar Karttunen