semi-stupid question (index on OID)

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: semi-stupid question (index on OID)
Date: 2001-05-04 19:35:53
Message-ID: Pine.BSO.4.10.10105041532460.21286-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-05-04 19:43:52 Re: Technical Suggestion Pl. Clarrify.
Previous Message Alex Pilosov 2001-05-04 19:12:23 Re: debugging Pl/Tcl