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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
