Re: [PERFORM] Ways to speed up ts_rank

2012-10-10 Thread Shane Hathaway
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

Re: [PERFORM] Ways to speed up ts_rank

2012-10-10 Thread Shane Hathaway
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

[PERFORM] Ways to speed up ts_rank

2012-10-09 Thread Shane Hathaway
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