On 10/10/2012 08:59 AM, Oleg Bartunov wrote:
We'll present in Prague some improvements in FTS. Unfortunately, we have
only several minutes during lighting talk. In short, we improved GIN to
store additional information, coordinates for fts, for example and
return ordered by rank search results, w
On 10/10/2012 06:38 AM, François Beausoleil wrote:
Notice the ts_rank() is on the outer query, which means it'll only
run on the subset of documents which match the query. This is
explicitly mentioned in the docs:
"""Ranking can be expensive since it requires consulting the tsvector
of each matc
We'll present in Prague some improvements in FTS. Unfortunately, we have
only several minutes during lighting talk. In short, we improved GIN to
store additional information, coordinates for fts, for example and return
ordered by rank search results, which gave us performance better than
sphynx.
Le 2012-10-09 à 17:38, Shane Hathaway a écrit :
> Hello,
>
> The database has a text index of around 200,000 documents. Investigation
> revealed that text queries are slow only when using ts_rank or ts_rank_cd.
> Without a ts_rank function, any query is answered within 200ms or so; with
> ts
Hello,
First let me say thanks for a fantastic database system. The hard work
this community has put into Postgres really shows.
A client of mine has been using Postgres quite effectively for a while
now, but has recently hit a performance issue with text index queries,
specifically when us
