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

Поиск
Список
Период
Сортировка
От Nicolas Grilly
Тема Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Дата
Msg-id CAG3yVS55NiOKrUWPceq7kXJBwAyXSssOefyCPQ02DQCKh4AP9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Full text search ranking: ordering using index and proximiti ranking with OR queries  (Andrey Chursin <andll@danasoft.ws>)
Ответы Re: Full text search ranking: ordering using index and proximiti ranking with OR queries  (Nicolas Grilly <nicolas@gardentechno.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Andrew Gould
Дата:
Сообщение: Re: Automated Backup Script Help (Linux)
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Automated Backup Script Help (Linux)