| From: | "Janek Sendrowski" <janek12(at)web(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | ORDER BY using index, tsearch2 |
| Date: | 2013-12-11 22:29:30 |
| Message-ID: | trinity-c65fe076-4523-4971-999c-367286014ca9-1386800970193@3capp-webde-bs11 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>
<div> </div>
<div>How can I use this ORDER BY using index feature presented in this implementation.</div>
<div>It doesn't seem to be in use, when I have a look in my query plan.</div>
<div>It still does an cost intensive Bitmap Heap Scan and a Bitmap Index scan.</div>
<div>I also can't find the "><" operator in any introduction of the tsearch2 extension.</div>
<div>Is it just an idea?</div>
<div> </div>
<div>Thanks for your help!</div>
<div>Janek Sendrowski</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 626 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janek Sendrowski | 2013-12-11 22:31:48 | ORDER BY using index, tsearch2 [READ THIS!] |
| Previous Message | Michael Sacket | 2013-12-11 15:41:07 | When is a query slow? |