Re: OID Perfomance - Object-Relational databases

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: OID Perfomance - Object-Relational databases
Дата
Msg-id web-1097898@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на OID Perfomance - Object-Relational databases  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: OID Perfomance - Object-Relational databases  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: OID Perfomance - Object-Relational databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Bruce, Tom, etc.:

> > This is what I mean.  Does the DB engine only recycle
> > *unused* OIDs (that is, does it check for teh continued
> > existance of a tuple with OID 198401)?  If that's the
> > method, then there isn't really a problem even if I do
> use
> > OIDs as a primary index.  None of my OIDs still in use
> will
> > be touched.
> 
> 
> No, it uses all oids, and can create duplicates.

Does this mean that Tom's "Wraparound Ragnarok" is the
accurate scenario?

-Josh Berkus


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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: OID Perfomance - Object-Relational databases
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: OID Perfomance - Object-Relational databases