AW: [HACKERS] Well, then you keep your darn columns

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: [HACKERS] Well, then you keep your darn columns
Дата
Msg-id 219F68D65015D011A8E000006F8590C603FDC222@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> >But the decision was (from Vadim IIRC) to drop them, at 
> least in non system
> >tables.
> >The cited reasons were:
> >* crappy implementation that taxed performance (probably 
> fixed by now)
> >* nobody else seemed to have them and the push then was to 
> the direction of
> >  mainstream bean-counting DB with main objective of getting 
> that base
> >  functionality right.
> 
> Regarding this last, Oracle has an equivalent - rowid.   In the web
> toolkit I'm helping port, it's used somewhat often, and having oid
> available has been a convenience.

rowid's are something completely different.
They do exist in Postgresql, and are called xtid.
(I suggested naming them rowid on the SQL level)
They have the advantage, that they don't need an index,
because they represent the physical location of the row.

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Well, then you keep your darn columns