From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Howard Rogers <hjr(at)diznix(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Full Text Search dictionary issues |
Date: | 2010-07-16 15:16:27 |
Message-ID: | 4C4077CB.9010002@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-07-16 16:40:08 | Re: pg_dump and --inserts / --column-inserts |
Previous Message | Steve Grey | 2010-07-16 15:02:27 | Re: Full Text Search dictionary issues |