Re: Index containing records instead of pointers to the data?

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: Index containing records instead of pointers to the data?
Дата
Msg-id 4E7697C1.1080407@emolecules.com
обсуждение исходный текст
Ответ на Index containing records instead of pointers to the data?  (Stefan Keller <sfkeller@gmail.com>)
Список pgsql-performance
On 9/18/11 1:18 PM, Stefan Keller wrote:
> Hi,
>
> Sorry if this is an odd question:
> I assume that Postgres indexes don't store records but only pointers
> to the data.
> This means, that there is always an additional access needed (real table I/O).
> Would an index containing data records make sense?
See my post entitled, "How to make hash indexes fast" for a solution to the additional-disk-access problem.

Craig
>
> Stefan
>


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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Index containing records instead of pointers to the data?
Следующее
От: Craig James
Дата:
Сообщение: How to make hash indexes fast