Re: semi-stupid question (index on OID) - Mailing list pgsql-general

From Tom Lane
Subject Re: semi-stupid question (index on OID)
Date
Msg-id 1660.989014861@sss.pgh.pa.us
Whole thread Raw
In response to semi-stupid question (index on OID)  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
Alex Pilosov <alex@pilosoft.com> writes:
> I though that searches on a table based on oid should be very fast (select
> * from table where oid=####), however, this doesn't appear to be the case.

Not unless you create an index on OID.

> My assumption was that essentially, if there is no clustering on the
> table, it is physically ordered by OID. Is that correct?

No, OID has little or nothing to do with physical location.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Daylight savings
Next
From: Tom Lane
Date:
Subject: Re: Re: commit_delay CANCEL