Re: Possibility of Index-Only access in PostgreSQL? - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Possibility of Index-Only access in PostgreSQL?
Date
Msg-id 007c01c21d8d$e94e9230$0200a8c0@SOL
Whole thread Raw
In response to Possibility of Index-Only access in PostgreSQL?  (Gunther Schadow <gunther@aurora.regenstrief.org>)
List 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






pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: pg_restore cannot restore function
Next
From: q u a d r a
Date:
Subject: graphical interface - admin