Re: text search: restricting the number of parsed words in headline generation - Mailing list pgsql-hackers

From Sushant Sinha
Subject Re: text search: restricting the number of parsed words in headline generation
Date
Msg-id 1314149321.1819.11.camel@dragflick
Whole thread Raw
In response to Re: text search: restricting the number of parsed words in headline generation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: text search: restricting the number of parsed words in headline generation
List pgsql-hackers
> > Here is a simple patch that limits the number of words during the
> > tokenization phase and puts an upper-bound on the headline generation.
> 
> Doesn't this force the headline to be taken from the first N words of
> the document, independent of where the match was?  That seems rather
> unworkable, or at least unhelpful.
> 
>             regards, tom lane

In headline generation function, we don't have any index or knowledge of
where the match is. We discover the matches by first tokenizing and then
comparing the matches with the query tokens. So it is hard to do
anything better than first N words.


One option could be that we start looking for "good match" while
tokenizing and then stop if we have found good match. Currently the
algorithms that decide a good match operates independently of the
tokenization and there are two of them. So integrating them would not be
easy.

The patch is very helpful if you believe in the common case assumption
that most of the time a good match is at the top of the document.
Typically a search application generates headline for the top matches of
a query i.e., those in which the query terms appears frequently. So
there should be atleast one or two good text excerpt matches at the top
of the document.



-Sushant.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: REGRESS_OPTS default
Next
From: Tom Lane
Date:
Subject: Re: Question: CREATE EXTENSION and create schema permission?