Re: Possibility of Index-Only access in PostgreSQL?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Gunther Schadow" <gunther(at)aurora(dot)regenstrief(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Possibility of Index-Only access in PostgreSQL?
Date: 2002-06-27 03:51:25
Message-ID: 007c01c21d8d$e94e9230$0200a8c0@SOL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> - 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jrg Holetschek 2002-06-27 09:52:54 CHECK clause doesn't work with CASE clause
Previous Message Jie Liang 2002-06-26 23:55:19 pg_restore cannot restore function