Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT
Date: 2009-10-21 13:37:53
Message-ID: 26975.1256132273@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sergey Konoplev <gray(dot)ru(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-21 13:42:23 Re: How to use Logical Operators in Fulltext Search?
Previous Message Sam Jas 2009-10-21 13:28:04 Re: How to use Logical Operators in Fulltext Search?