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

From: Nicolas Grilly <nicolas(at)gardentechno(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Date: 2011-07-12 21:10:08
Message-ID: CAG3yVS56p2uXsNaC7OBbDid6SFVbw1q0-BHMEn5Z55avkVZ3pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 12, 2011 at 22:25, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2011-07-12 22:47:13 Re: Unexpected results with joins on dates
Previous Message Oleg Bartunov 2011-07-12 20:25:08 Re: ts_rank seems very slow (140 ranked documents / second on my machine)