Re: OID Usage

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: OID Usage
Date: 2005-01-15 16:11:16
Message-ID: 41E940A4.30308@netgroup.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:

>Most system catalogs use OIDs as primary keys. So they cannot just
>disappear. But on user tables, there's not a lot of use for them IMHO.
>
>
Ok, I think it is about time it is stated more clearly in the documentation.

>There's no internal row id on Postgres; having one would mean more
>storage requirements. If you want one, you know where to get it ... if
>not, you may as well save the space.
>
>
So, how does a index relate to a row ? There have to be some way of
addressing a row ?

/BL

In response to

Responses

  • Re: OID Usage at 2005-01-15 17:06:50 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Berteun Damman 2005-01-15 16:16:01 Pgsql taking a *lot* of CPU time (unkillable).
Previous Message Michael Fuhr 2005-01-15 15:27:25 Re: is there anyway to get the backends IP address from the PID?