From: Shane Hathaway <shane@hathawaymix.org>
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: François Beausoleil <francois@teksol.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: Ways to speed up ts_rank
Date: Wed, 10 Oct 2012 12:32:55 -0600
Message-ID: <5075BF57.9010602@hathawaymix.org> (raw)
In-Reply-To: <Pine.LNX.4.64.1210101854460.1008@sn.sai.msu.ru>
References: <5074996C.5020809@hathawaymix.org>
<546C964C-5BE7-464D-9EC6-5FC816AEE65E@teksol.info>
<Pine.LNX.4.64.1210101854460.1008@sn.sai.msu.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shane@hathawaymix.org, oleg@sai.msu.su, francois@teksol.info
Subject: Re: Ways to speed up ts_rank
In-Reply-To: <5075BF57.9010602@hathawaymix.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox