Index containing records instead of pointers to the data?

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Index containing records instead of pointers to the data?
Date: 2011-09-18 20:18:45
Message-ID: CAFcOn2_SUv=C2CqOQn6_mjOLQ9f9eqsSG3JBE2S5dzbSWp_piw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Stefan

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thom Brown 2011-09-18 20:21:52 Re: Index containing records instead of pointers to the data?
Previous Message Peter Geoghegan 2011-09-18 20:06:32 Re: What about implementing a bitmap index? Any use cases?