Re: ORDER BY using index, tsearch2

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: ORDER BY using index, tsearch2
Дата
Msg-id CAFwQ8rc=R=S3RFZzQkGjNgYpQQHQcyA9NAw+aU45SK-mniKPMg@mail.gmail.com
обсуждение исходный текст
Ответ на ORDER BY using index, tsearch2  ("Janek Sendrowski" <janek12@web.de>)
Ответы Re: ORDER BY using index, tsearch2
Список pgsql-performance
Дерево обсуждения
On Wed, Dec 11, 2013 at 2:29 PM, Janek Sendrowski <janek12@web.de> wrote:
Hi,
 
How can I use this ORDER BY using index feature presented in this implementation.
It doesn't seem to be in use, when I have a look in my query plan.
It still does an cost intensive Bitmap Heap Scan and a Bitmap Index scan.
I also can't find the "><" operator in any introduction of the tsearch2 extension.
Is it just an idea?

A GIST is a tree, but there's no notion of ">" or "<", only yes/no at each tree branch.  In this regard a GIST index is more like a hash table.  You can't use a hash table to sort.  It doesn't make sense.

Craig

 
Thanks for your help!
Janek Sendrowski

В списке pgsql-performance по дате отправления: