pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedORDER BY using index, tsearch2 [READ THIS!]
2+ messages / 2 participants
[nested] [flat]
* ORDER BY using index, tsearch2 [READ THIS!]
@ 2013-12-11 22:31 Janek Sendrowski <janek12@web.de>
0 siblings, 1 reply; 2+ messages in thread
From: Janek Sendrowski @ 2013-12-11 22:31 UTC (permalink / raw)
To: pgsql-performance
[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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ORDER BY using index, tsearch2 [READ THIS!]
@ 2013-12-11 23:33 Tom Lane <tgl@sss.pgh.pa.us>
parent: Janek Sendrowski <janek12@web.de>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2013-12-11 23:33 UTC (permalink / raw)
To: Janek Sendrowski <janek12@web.de>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-12-11 23:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-12-11 22:31 ORDER BY using index, tsearch2 [READ THIS!] Janek Sendrowski <janek12@web.de>
2013-12-11 23:33 ` Tom Lane <tgl@sss.pgh.pa.us>
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