Re: Re: OID wraparound: summary and proposal
От
Hiroshi Inoue
Тема
Re: Re: OID wraparound: summary and proposal
Дата
Msg-id
3B6DD7B9.770AA22@tpf.co.jp
Список
Дерево обсуждения
Re: OID wraparound: summary and proposal mlw <markw@mohawksoft.com>
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 по дате отправления