Re: Re: OID wraparound: summary and proposal - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Re: OID wraparound: summary and proposal
Date
Msg-id 3B6DD7B9.770AA22@tpf.co.jp
Whole thread Raw
In response to RE: Re: OID wraparound: summary and proposal  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible solution for LIKE optimization
Next
From: Peter Eisentraut
Date:
Subject: Re: Linking a shared library against a C function