Re: ORDER BY using index, tsearch2

[Craig James <cjames@xxxxxxxxxxxxxx>]

On Wed, Dec 11, 2013 at 2:29 PM, Janek Sendrowski <janek12@xxxxxx> 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