Re: Re: OID wraparound: summary and proposal
| От | Hiroshi Inoue |
|---|---|
| Тема | Re: Re: OID wraparound: summary and proposal |
| Дата | |
| Msg-id | 3B6DD7B9.770AA22@tpf.co.jp обсуждение исходный текст |
| Ответ на | RE: Re: OID wraparound: summary and proposal ("Hiroshi Inoue" <Inoue@tpf.co.jp>) |
| Список | pgsql-hackers |
mlw wrote: > > Hiroshi Inoue wrote: > > > > The analog of ROWID in PostgreSQL is TID rather than OID > > because TID is a physical address of a tuple within a table. > > However there's a significant difference. Unfortunately TID > > is transient. It is changed by UPDATE and VACUUM. > > Though TIDs are unavailable for critical use, OIDs could > > compensate the drawback. TIDs and OIDs must help each > > other if PostgreSQL needs the concept like ROWID. > > That is true now, but I am saying that it should not be true. Rather than have > a single limited global resource, the current OID, if possible, tables should > get their own notion of an OID, like a ROWID. > I've objected optional OID but never objected OIDs per table. OIDs per table is more important than others IMHO. regards, Hiroshi Inoue
В списке pgsql-hackers по дате отправления: