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

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index containing records instead of pointers to the data?
Date: 2011-09-19 01:15:45
Message-ID: 4E7697C1.1080407@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ondrej Ivanič 2011-09-19 01:25:16 Re: How to make hash indexes fast
Previous Message Craig James 2011-09-19 01:14:01 How to make hash indexes fast