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
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