Request a Demo
Home   >   mailing lists

ORDER BY using index, tsearch2 - Mailing list pgsql-performance

From Janek Sendrowski
Subject ORDER BY using index, tsearch2
Date
Msg-id trinity-c65fe076-4523-4971-999c-367286014ca9-1386800970193@3capp-webde-bs11
Whole thread Raw
Responses Re: ORDER BY using index, tsearch2
List pgsql-performance
Tree view
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 by date:

Previous
From: Michael Sacket
Date:
Subject: When is a query slow?
Next
From: "Janek Sendrowski"
Date:
Subject: ORDER BY using index, tsearch2 [READ THIS!]