Postgres Pro
Downloads
Home   >   mailing lists

Re: ts_rank seems very slow (140 ranked documents / second on my machine) - Mailing list pgsql-general

From Nicolas Grilly
Subject Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Date
Msg-id CAG3yVS56p2uXsNaC7OBbDid6SFVbw1q0-BHMEn5Z55avkVZ3pg@mail.gmail.com
Whole thread Raw
In response to Re: ts_rank seems very slow (140 ranked documents / second on my machine)  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: ts_rank seems very slow (140 ranked documents / second on my machine)
List pgsql-general
Tree view 
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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Next
From: Tim Uckun
Date:
Subject: Re: Unexpected results with joins on dates