Re: ts_headline

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

In response to

  • ts_headline at 2008-02-21 00:19:48 from Stephen Davies

Responses

Browse pgsql-general by date

  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

Browse pgsql-patches by date

  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