Re: OID Usage

Поиск
Список
Период
Сортировка
От Bo Lorentsen
Тема Re: OID Usage
Дата
Msg-id 41E95CA8.1@netgroup.dk
обсуждение исходный текст
Ответ на Re: OID Usage  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: OID Usage  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Martijn van Oosterhout wrote:

>But where in the documentation did you see anything saying that they
>were unique? I imagine you just inferred that from somewhere. I'm not
>sure where the documentation should be changed since nowhere actually
>recommends them in any way.
>
>
Hmm, how about as a comment near by the PGoidValue function ?

>Using the CTID, which locates the physical tuple as (block,num). When
>you update a tuple, or vacuum moves it its CTID will change, so it's
>not terribly useful from a user's point of view.
>
>
Hmm, so a data row update also update the CTID in all indexes, too. I
see what you mean !

>Hope this helps,
>
>
It did, thanks.

/BL

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

Предыдущее
От: Bo Lorentsen
Дата:
Сообщение: Index optimization ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pgsql taking a *lot* of CPU time (unkillable).