On 24 April 2014 13:34, Heikki Linnakangas <hlinnakangas@xxxxxxxxxx> wrote: > As the docs say, the GIN index does not store the weights. As such, there is > no need to strip them. A recheck would be necessary if your query needs the > weights, precisely because the weights are not included in the index. > > (In the OP's query, it's the ranking that was causing the detoasting.) Thanks! My problem is that I actually need the ranking. My queries can return a large number of documents (tens of thousands) but I usually need only the first couple of pages of most relevant results (e.g. 50-100 records). With PostgreSQL and tsearch2, this means that the tens of thousands of documents found via the index are then detoasted and ranked. Does anyone have experience with external search engines which also have ranking but are more efficient? How about Solr? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
