semi-stupid question (index on OID)

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема semi-stupid question (index on OID)
Дата
Msg-id Pine.BSO.4.10.10105041532460.21286-100000@spider.pilosoft.com
обсуждение исходный текст
Ответы Re: semi-stupid question (index on OID)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: OODBMS vs. RDBMS
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Case sensitive order by