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 по дате отправления: