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, which gave us performance better than sphynx. It's just a prototype, but we already got median at 8 msec for 6 mln classifieds. We didn't tested for long documents yet.
That sounds like the solution I'm looking for! Storing the info for ts_rank in an index would probably do the trick. Can I get this code somewhere? I've isolated the table I need to optimize and I can easily run tests on non-production code.
Shane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
