From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ts_headline |
Date: | 2008-02-21 08:49:37 |
Message-ID: | 47BD3B21.4090700@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-patches |
Stephen Davies wrote:
> I am a bit puzzled by the output of ts_headline (V8.3) for different queries.
> It seems that the difference is in the number of occurrences of the criterion
> words. If the number of hits is less than some number, the ts_headline result
> is "correct" but if the number of hits exceeds that limit, the result is just
> the first MinWords of the "document".
>
> I have seen cases with up to 20 hits succeed but cases with 35 hits miss.
> The spread of hits does not seem to be relevant.
http://www.postgresql.org/docs/8.3/static/textsearch-controls.html#TEXTSEARCH-HEADLINE
Are you bumping into the MaxWords limit? If you've got 35 hits that must
be at least 35 words.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | hewei | 2008-02-21 09:03:09 | Re: How to make update rapidly? |
Previous Message | Pascal Cohen | 2008-02-21 08:17:32 | Feedback on PLJava |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Davies | 2008-02-21 09:29:40 | Re: ts_headline |
Previous Message | Edwin Groothuis | 2008-02-21 07:16:53 | BUG #3975: tsearch2 index should not bomb out of 1Mb limit |