Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 69C61476C8C
	for <pgsql-sql@postgresql.org>; Wed, 26 Jun 2002 23:58:05 -0400 (EDT)
Mailbox-Line: From chriskl@familyhealth.com.au  Wed Jun 26 23:58:05 2002
Received: from mail.iinet.net.au (symphony-05.iinet.net.au [203.59.3.37])
	by postgresql.org (Postfix) with SMTP id B8212476498
	for <pgsql-sql@postgresql.org>; Wed, 26 Jun 2002 23:55:10 -0400 (EDT)
Received: (qmail 28611 invoked by uid 666); 27 Jun 2002 03:55:11 -0000
Received: from unknown (HELO SOL) (203.59.168.219)
	by iinet.net.au with SMTP; 27 Jun 2002 03:55:11 -0000
Message-ID: <007c01c21d8d$e94e9230$0200a8c0@SOL>
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Gunther Schadow" <gunther@aurora.regenstrief.org>,
	<pgsql-sql@postgresql.org>
References: <3D19FFCF.8030800@aurora.regenstrief.org>
Subject: Re: Possibility of Index-Only access in PostgreSQL?
Date: Thu, 27 Jun 2002 11:51:25 +0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
X-Spam-Status: No, hits=0.9 required=5.0
	tests=SUBJ_ENDS_IN_Q_MARK,RCVD_IN_MULTIHOP_DSBL,
	X_RCVD_IN_UNCONFIRMED_DSBL,FUDGE_MULTIHOP_RELAY version=2.30
X-Spam-Level: 
X-Archive-Number: 200206/360
X-Sequence-Number: 8325

> - Oracle is content with data read from an index if that is all that's
>    needed. Indeed, I only need bar and baz and those are in the index.
>    The benefits of not having to seek the scattered rows from the data
>    table saves 35000 back and forth head movements / seeks.

Postgres can't use the data from its indices, because of the MVCC mechanism.
Maybe you should try CLUSTERing your table to improve performance???

Chris