| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | Kapil Tilwani <tilwani(at)yahoo(dot)co(dot)uk> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OIDs overflow |
| Date: | 2001-06-14 12:06:23 |
| Message-ID: | Pine.LNX.4.33.0106141502250.25979-100000@melkinpaasi.cs.Helsinki.FI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | denis | 2001-06-14 12:07:47 | performance tuning or real bug ? |
| Previous Message | Tamsin | 2001-06-14 10:49:16 | RE: newbie:how can i get day of week data type... |