Re: TSearch and rankings - Mailing list pgsql-general

From Bas Scheffers
Subject Re: TSearch and rankings
Date
Msg-id 1131.217.205.40.94.1076343925.squirrel@io.scheffers.net
Whole thread Raw
In response to TSearch and rankings  ("Bas Scheffers" <bas@scheffers.net>)
List pgsql-general
Teodor Sigaev said:
> (foo&bar)|(foo&bar&doh)|(foo&bar&doh&other)
> will be equals to simple query foo&bar, because other variants is a
stronger
That sounds encouraging. My "documents" are actualy quite small. That is
because they are not documents, but just keywords for a user's profile.
(like age28, height187, countryuk, etc) So my documents won't have much
more than 20-25 terms to begin with.

But you do get queries like
'(age25|age26|...|age35)&(height180|...|height200)&countryuk)'

I tested this with a 10000 user database last night on my Athlon 850/384MB
and queries returned actrately in <150ms (and this included a normal where
clause on the base table I need to do as well) So so far I am impressed.

I'll test with a 100K user set later this week, using the "maybe" query
style and let you know my results.

Thanks again,
Bas.



pgsql-general by date:

Previous
From: John Gibson
Date:
Subject: Quad Xeon vs. Dual Itanium
Next
From: Barbara Lindsey
Date:
Subject: setting default value by "trigger"