From: Tom Lane <tgl@sss.pgh.pa.us>
To: Janek Sendrowski <janek12@web.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: ORDER BY using index, tsearch2 [READ THIS!]
Date: Wed, 11 Dec 2013 18:33:32 -0500
Message-ID: <16510.1386804812@sss.pgh.pa.us> (raw)
In-Reply-To: <trinity-490be654-f0b7-4bb3-a332-5c3aa1ef8125-1386801108245@3capp-webde-bs11>
References: <trinity-c65fe076-4523-4971-999c-367286014ca9-1386800970193@3capp-webde-bs11>
<trinity-490be654-f0b7-4bb3-a332-5c3aa1ef8125-1386801108245@3capp-webde-bs11>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
"Janek Sendrowski" <janek12@web.de> writes:
> 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?
We're not in the habit of documenting nonexistent features, if that's what
you mean. However, you've not provided nearly enough information for
anyone to help you; at minimum, the index definitions you have, the query
you gave, the plan you got, and the exact PG version would be critical
information. More information about asking answerable questions can be
found here:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Also, I'm a bit troubled by your reference to tsearch2, because that
contrib module is obsolete, and has been since well before any PG version
that has a feature like what I think you're asking about. So I wonder if
you are reading documentation not applicable to the version you're working
with.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, janek12@web.de
Subject: Re: ORDER BY using index, tsearch2 [READ THIS!]
In-Reply-To: <16510.1386804812@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox