Re: History of oids in postgres? - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: History of oids in postgres?
Date
Msg-id 200405051703.i45H3Uc22406@candle.pha.pa.us
Whole thread Raw
In response to History of oids in postgres?  (James Robinson <jlrobins@socialserve.com>)
List pgsql-performance
James Robinson wrote:
> Bruno et al,
>
>     Any self-repsecting lurker would know that oids as row identifiers are
> depreciated in postgres. Can anyone provide a brief history regarding
> the reasoning behind using them as row identifiers in the first place?
> I see a discussion of their use as various primary keys in he system
> catalog in the oid-datatype doc page, but not regarding their history
> as 'user-space' row ids.

They were added at Berkeley and I think are related to the
Object-relational ability of PostgreSQL.  I think the newer SQL
standards have a similar capability specified.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: "Jie Liang"
Date:
Subject: LIKE and INDEX
Next
From: Paul Tuckfield
Date:
Subject: Re: very high CPU usage in "top", but not in "mpstat"