Re: tsearch2, large data and indexes

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: tsearch2, large data and indexes
Дата
Msg-id CAF-QHFWNt-+AKyYQDf=d56b198tRObmfrNwzBj78h2CLUw3T4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tsearch2, large data and indexes  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: tsearch2, large data and indexes
Список pgsql-performance
On 24 April 2014 13:34, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:

> As the docs say, the GIN index does not store the weights. As such, there is
> no need to strip them. A recheck would be necessary if your query needs the
> weights, precisely because the weights are not included in the index.
>
> (In the OP's query, it's the ranking that was causing the detoasting.)

Thanks!

My problem is that I actually need the ranking. My queries can return
a large number of documents (tens of thousands) but I usually need
only the first couple of pages of most relevant results (e.g. 50-100
records). With PostgreSQL and tsearch2, this means that the tens of
thousands of documents found via the index are then detoasted and
ranked.

Does anyone have experience with external search engines which also
have ranking but are more efficient? How about Solr?


В списке pgsql-performance по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: tsearch2, large data and indexes
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: tsearch2, large data and indexes