ORDER BY using index, tsearch2 [READ THIS!]

Поиск
Список
Период
Сортировка
От Janek Sendrowski
Тема ORDER BY using index, tsearch2 [READ THIS!]
Дата
Msg-id trinity-490be654-f0b7-4bb3-a332-5c3aa1ef8125-1386801108245@3capp-webde-bs11
обсуждение исходный текст
Ответ на ORDER BY using index, tsearch2  ("Janek Sendrowski" <janek12@web.de>)
Ответы Re: ORDER BY using index, tsearch2 [READ THIS!]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
[Sorry, this previous mail was HTML-foramted]

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?
 
Thanks for your help!
Janek Sendrowski


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

Предыдущее
От: "Janek Sendrowski"
Дата:
Сообщение: ORDER BY using index, tsearch2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ORDER BY using index, tsearch2 [READ THIS!]