Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id C746AB5DC01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 18 Sep 2011 22:13:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 29623-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 19 Sep 2011 01:13:07 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com
	[209.85.210.42])
	by mail.postgresql.org (Postfix) with ESMTP id 667A2B5DC02
	for <pgsql-performance@postgresql.org>;
	Sun, 18 Sep 2011 22:13:07 -0300 (ADT)
Received: by pzk1 with SMTP id 1so9408042pzk.1
	for <pgsql-performance@postgresql.org>;
	Sun, 18 Sep 2011 18:13:07 -0700 (PDT)
Received: by 10.68.71.195 with SMTP id x3mr3495706pbu.157.1316394787166;
	Sun, 18 Sep 2011 18:13:07 -0700 (PDT)
Received: from Craig-Jamess-MacBook-Pro.local (mta-76-176-59-179.san.rr.com.
	[76.176.59.179])
	by mx.google.com with ESMTPS id i8sm40225835pbl.2.2011.09.18.18.13.05
	(version=SSLv3 cipher=OTHER); Sun, 18 Sep 2011 18:13:06 -0700 (PDT)
Message-ID: <4E7697C1.1080407@emolecules.com>
Date: Sun, 18 Sep 2011 18:15:45 -0700
From: Craig James <craig_james@emolecules.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6;
	rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Index containing records instead of pointers to the
 data?
References: 
 <CAFcOn2_SUv=C2CqOQn6_mjOLQ9f9eqsSG3JBE2S5dzbSWp_piw@mail.gmail.com>
In-Reply-To: 
 <CAFcOn2_SUv=C2CqOQn6_mjOLQ9f9eqsSG3JBE2S5dzbSWp_piw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201109/250
X-Sequence-Number: 45026

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
>