tsvector minimum match using index - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject tsvector minimum match using index
Date
Msg-id 20100128142347.58bc21b6@dawn.webthatworks.it
Whole thread Raw
List pgsql-general
Would it be possible without writing a very long tsquery to exploit
the index to retrieve the tsvectors that contain at least N lexemes?

If not exploiting the index... any suggestion to improve performance
of such a query?

computing rank still requires retrieving a lot of tsvectors and
compute the rank for each of them.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Function nesting issue
Next
From: 张海峰
Date:
Subject: Re: Function nesting issue