Re: Full Text Search dictionary issues

On 16/07/10 05:22, Howard Rogers wrote:
> OK, Tom: I did actually account for the number of rows difference
> before I posted, though I accept I didn't show you that. So here goes:

Tom's good, but his mind-reading powers aren't what they used to be :-)

> ims=# select count(*)
> ims-# from search_rm
> ims-# where to_tsvector('english', textsearch) @@
> to_tsquery('english', 'wommmman&  batt&  ftxa')
> ims-# limit 20;
>   count
> -------
>      0
> (1 row)
>
> Time: 0.593 ms
> ims=# select count(*)
> from search_rm
> where to_tsvector('english', textsearch) @@ to_tsquery('english',
> 'wommmman&  batt&  ftx1')
> limit 20;
>   count
> -------
>      0
> (1 row)
>
> Time: 489.362 ms
>
> Both queries return zero rows. One takes an awful lot longer than the
> other.

And how many matches do you get for each term? Is it equally slow if you
search for 'wommman & batt && pzsdja' vs '... pzsdj1'?

I'm assuming pzsdja/1 aren't valid tokens of course...

--
   Richard Huxton
   Archonet Ltd