Re: index-only scans - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: index-only scans
Date
Msg-id CAPpHfdsx8e0tDgbFCZdPQKG9765FDhdNuLD1gkgc8q_GESkUdA@mail.gmail.com
Whole thread Raw
In response to Re: index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Oct 12, 2011 at 12:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Hm.  I had been supposing that lossless compress functions would just be
no-ops.  If that's not necessarily the case then we might need something
different from the opclass's decompress function to get back the
original data.  However, that doesn't really solve the problem I'm
concerned about, because the existence and use of such a function would
be entirely internal to GiST.  There still needs to be a way for the
planner to know which opclasses support data retrieval.  And I do *not*
want to see us hard-wire "the presence of opclass function 8 means a
GiST opclass can return data" into the planner.

Maybe, instead of a simple constant amcanreturn column, we need an AM
API function that says whether the index can return data.
I like idea of such AM API function. Since single multicolumn index can use multiple opclasses, AM API function should also say *what* data index can return.
 
------
With best regards,
Alexander Korotkov. 

pgsql-hackers by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Overhead cost of Serializable Snapshot Isolation
Next
From: Dimitri Fontaine
Date:
Subject: Re: ALTER EXTENSION .. ADD/DROP weirdness