Re: Full text search ranking: ordering using index and proximiti ranking with OR queries

From: Nicolas Grilly <nicolas(at)gardentechno(dot)com>
To: Andrey Chursin <andll(at)danasoft(dot)ws>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Date: 2012-03-07 19:05:54
Message-ID: CAG3yVS55NiOKrUWPceq7kXJBwAyXSssOefyCPQ02DQCKh4AP9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In a previous discussion thread, Oleg suggested that ts_rank is unable to
use GIN indices:
http://archives.postgresql.org/pgsql-general/2011-07/msg00351.php

This is the only information I have about this.

On Wed, Mar 7, 2012 at 18:59, Andrey Chursin <andll(at)danasoft(dot)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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-03-07 19:08:23 Re: Automated Backup Script Help (Linux)
Previous Message Andrew Gould 2012-03-07 18:58:24 Re: Automated Backup Script Help (Linux)