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 по дате отправления
От: Tom Lane
Дата:
От: Peter Eisentraut
Дата:
FAQ