Postgres Pro
Downloads
Home   >   mailing lists

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

From Stefan Keller
Subject Index containing records instead of pointers to the data?
Date
Msg-id CAFcOn2_SUv=C2CqOQn6_mjOLQ9f9eqsSG3JBE2S5dzbSWp_piw@mail.gmail.com
Whole thread Raw
Responses Re: Index containing records instead of pointers to the data?  (Thom Brown <thom@linux.com>)
Re: Index containing records instead of pointers to the data?  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: What about implementing a bitmap index? Any use cases?
Next
From: Thom Brown
Date:
Subject: Re: Index containing records instead of pointers to the data?