Re: ts_rank seems very slow (140 ranked documents / second on my machine)

Поиск
Список
Период
Сортировка
От Nicolas Grilly
Тема Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Дата
Msg-id CAG3yVS56p2uXsNaC7OBbDid6SFVbw1q0-BHMEn5Z55avkVZ3pg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ts_rank seems very slow (140 ranked documents / second on my machine)  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: ts_rank seems very slow (140 ranked documents / second on my machine)  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
Дерево обсуждения 
On Tue, Jul 12, 2011 at 22:25, Oleg Bartunov <oleg@sai.msu.su> wrote:
> I don't see your query uses index :)

Yes, I know. :)

I ran VACUUM ANALYZE and re-ran the query but the output of EXPLAIN
ANALYZE stays exactly the same: no index used.

Any idea why?

By the way, does ts_rank is supposed to use a GIN index when it's available?

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Следующее
От: Tim Uckun
Дата:
Сообщение: Re: Unexpected results with joins on dates