Re: Index-only quals

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Index-only quals
Дата
Msg-id 407d949e0908210513o24812144ncb82df2f3d8b34dc@mail.gmail.com
обсуждение исходный текст
Ответ на Index-only quals  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Index-only quals
Re: Index-only quals
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Index-only quals
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Index-only quals