Postgres Pro
Downloads
Home   >   mailing lists

Re: Full text search ranking: ordering using index and proximiti ranking with OR queries - Mailing list pgsql-general

From Nicolas Grilly
Subject Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Date
Msg-id CAG3yVS55NiOKrUWPceq7kXJBwAyXSssOefyCPQ02DQCKh4AP9w@mail.gmail.com
Whole thread Raw
In response to Re: Full text search ranking: ordering using index and proximiti ranking with OR queries  (Andrey Chursin <andll@danasoft.ws>)
Responses Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
List pgsql-general
Tree view
In a previous discussion thread, Oleg suggested that ts_rank is unable to use GIN indices:

This is the only information I have about this.

On Wed, Mar 7, 2012 at 18:59, Andrey Chursin <andll@danasoft.ws> wrote:
Is there any way to sort by ranking, avoiding seq scan?
The only way i see now is to use pg_trgm instead of ts_rank, but we
did not check yet how applicable is it for our purposes.

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: Automated Backup Script Help (Linux)
Next
From: John R Pierce
Date:
Subject: Re: Automated Backup Script Help (Linux)