Postgres Pro
Downloads
Home   >   mailing lists

Re: Index containing records instead of pointers to the data? - Mailing list pgsql-performance

From Craig James
Subject Re: Index containing records instead of pointers to the data?
Date
Msg-id 4E7697C1.1080407@emolecules.com
Whole thread Raw
In response to Index containing records instead of pointers to the data?  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Thom Brown
Date:
Subject: Re: Index containing records instead of pointers to the data?
Next
From: Craig James
Date:
Subject: How to make hash indexes fast