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 CAG3yVS797eFxcs0B-s-=ZjG2YLzPt=_zD-5hfV7q1SSrExpyow@mail.gmail.com
Whole thread Raw
In response to Re: Full text search ranking: ordering using index and proximiti ranking with OR queries  (Nicolas Grilly <nicolas@gardentechno.com>)
List pgsql-general
Tree view
There is some good news coming from Oleg Bartunov and Alexander Korotkov about improving ranking speed:

It's worth reading their slides to gain a better understanding of PostgreSQL fulltext internals.


On Wed, Mar 7, 2012 at 8:05 PM, Nicolas Grilly <nicolas@gardentechno.com> wrote:
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.

pgsql-general by date:

Previous
From: Vlad
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Lee Hachadoorian
Date:
Subject: Re: Check table storage parameters