Re: Does Oracle store values in indices?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does Oracle store values in indices?
Дата
Msg-id 8248.980290879@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: Does Oracle store values in indices?  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> We could add transaction data to index tuples but this would increase
> their size by ~ 16bytes.

The increased space is the least of the drawbacks.  Consider also the
time needed to maintain N copies of a tuple's commit status instead of
one.  Even finding the N copies would cost a lot more than the single
disk transfer involved now ...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] binary operators on integers
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: pg_shadow.usecatupd attribute