On 18 September 2011 21:18, Stefan Keller <sfkel...@gmail.com> 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?
Yes, it's called a covering index, where the data required to produce results for the query are entirely contained in the index. That should be hopefully coming in 9.2. See http://wiki.postgresql.org/wiki/Index-only_scans -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
