Re: History of oids in postgres?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: History of oids in postgres?
Дата
Msg-id 200405051703.i45H3Uc22406@candle.pha.pa.us
обсуждение исходный текст
Ответ на History of oids in postgres?  (James Robinson <jlrobins@socialserve.com>)
Список 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 по дате отправления:

Предыдущее
От: "Jie Liang"
Дата:
Сообщение: LIKE and INDEX
Следующее
От: Paul Tuckfield
Дата:
Сообщение: Re: very high CPU usage in "top", but not in "mpstat"