On Thu, Apr 24, 2014 at 5:34 AM, Ivan Voras <ivo...@freebsd.org> wrote: > On 24 April 2014 13:34, Heikki Linnakangas <hlinnakan...@vmware.com> 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.
Heikki, what about the "GIN improvements part 3: ordering in index" patch, was it committed? http://www.postgresql.org/message-id/flat/capphfduwvqv5b0xz1dzuqaw29erdculzp2wotfjzdbs7bhp...@mail.gmail.com Ivan, there is a hope that we could get a more effective FTS solution that any others I have heard about with this patch. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray...@gmail.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
