Re: Index-only quals - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Index-only quals
Date
Msg-id 407d949e0908210513o24812144ncb82df2f3d8b34dc@mail.gmail.com
Whole thread Raw
In response to Index-only quals  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Index-only quals  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Index-only quals  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Fri, Aug 21, 2009 at 12:43 PM, Heikki
Linnakangas<heikki.linnakangas@enterprisedb.com> wrote:
> Here is an updated version of my patch to return data from b-tree
> indexes, and use it to satisfy quals.

+             if (!found_clause && useful_pathkeys == NIL && !useful_predicate)
+                 ipath->scantype = ST_INDEXSCAN;
+             else
+             {
+                 ipath->scantype = 0;
+                 if (index->amhasgettuple)
+                     ipath->scantype |= ST_INDEXSCAN;
+                 if (index->amhasgetbitmap)
+                     ipath->scantype |= ST_BITMAPSCAN;
+             }
+


Does this section need to check amhasgettuple for the index-only scan
case as well? It looks like right now if an indexam has amregurgitate
set but not amhasgettuple then weird things could happen.

-- 
greg
http://mit.edu/~gsstark/resume.pdf


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Index-only quals
Next
From: Heikki Linnakangas
Date:
Subject: Re: Index-only quals