Re: OID Usage - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: OID Usage
Date
Msg-id 41E95CA8.1@netgroup.dk
Whole thread Raw
In response to Re: OID Usage  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: OID Usage  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: Bo Lorentsen
Date:
Subject: Index optimization ?
Next
From: Tom Lane
Date:
Subject: Re: Pgsql taking a *lot* of CPU time (unkillable).