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

From Alex Pilosov
Subject semi-stupid question (index on OID)
Date
Msg-id Pine.BSO.4.10.10105041532460.21286-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: semi-stupid question (index on OID)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

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.

My assumption was that essentially, if there is no clustering on the
table, it is physically ordered by OID. Is that correct? Or vacuum may
rearrange tuples without regard of their order? (...how does vacuum cope
with clustered tables then?)

-alex


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: OODBMS vs. RDBMS
Next
From: Bruno Wolff III
Date:
Subject: Re: Case sensitive order by