tsvector minimum match using index

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: tsvector minimum match using index
Date: 2010-01-28 13:23:47
Message-ID: 20100128142347.58bc21b6@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message 张海峰 2010-01-28 13:26:26 Re: Function nesting issue
Previous Message Tamanna 2010-01-28 11:58:05 Re: logtrigger/denyaccess triggers removed from master/slave