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.