OIDs overflow

От:

"Kapil Tilwani" <tilwani@yahoo.co.uk>

Дата:

12 июня 2001 г. в 15:30:34

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

Re: OIDs overflow

От:

Einar Karttunen <ekarttun@cs.Helsinki.FI>

Дата:

14 июня 2001 г. в 08:06:51

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