Postgres Pro
Downloads
Home   >   mailing lists

ORDER BY using index, tsearch2 [READ THIS!] - Mailing list pgsql-performance

From Janek Sendrowski
Subject ORDER BY using index, tsearch2 [READ THIS!]
Date
Msg-id trinity-490be654-f0b7-4bb3-a332-5c3aa1ef8125-1386801108245@3capp-webde-bs11
Whole thread Raw
In response to ORDER BY using index, tsearch2  ("Janek Sendrowski" <janek12@web.de>)
Responses Re: ORDER BY using index, tsearch2 [READ THIS!]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
[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 by date:

Previous
From: "Janek Sendrowski"
Date:
Subject: ORDER BY using index, tsearch2
Next
From: Tom Lane
Date:
Subject: Re: ORDER BY using index, tsearch2 [READ THIS!]