Re: Problem with site doc search

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>, "Gevik Babakhani" <pgdev(at)xs4all(dot)nl>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
Subject: Re: Problem with site doc search
Date: 2008-04-16 09:15:18
Message-ID: 200804161115.23980.cedric.villemain@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le Wednesday 16 April 2008, Magnus Hagander a écrit :
> Cédric Villemain wrote:
> > Notice that :
> >
> > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=r
> > and
> > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=d
> >
> > do not provide same result (3 results by date, 1 by rank) even if
> > only the sorting is changed.
>
> Actually, I get 5 and 7, in the other order.
>
> The reason for this is that Tom Lane is way too active. It's
> gin_fuzzy_search_limit that's doing the restriction first, and the date
> restriction comes in later.

Yes, you are perfectly right. Can I suggest to deactivate
gin_fuzzy_search_limit (or increase the value) when one condition (and use
the condition earlier) can considerably reduce the number of results (like
the 'post date' here) ?

>
> //Magnus

--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-04-16 09:25:12 Re: Problem with site doc search
Previous Message Magnus Hagander 2008-04-16 08:55:12 Re: Problem with site doc search