Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT - Mailing list pgsql-general

From Tom Lane
Subject Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT
Date
Msg-id 26975.1256132273@sss.pgh.pa.us
Whole thread Raw
In response to Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view 
Sergey Konoplev <gray.ru@gmail.com> writes:
> Is there a way (or workaround) to make it use i_test_table__created
> for frequent and i_test_table__tsvector_1 for sparse words?

You would need to update to 8.4 for that --- 8.3 does not have any
support for statistics estimation for @@.

(Whether 8.4 would get it right is a different question, but at least
it has a chance.  8.3 has none.)

            regards, tom lane

pgsql-general by date:

Previous
From: Sam Jas
Date:
Subject: Re: How to use Logical Operators in Fulltext Search?
Next
From: Tom Lane
Date:
Subject: Re: How to use Logical Operators in Fulltext Search?