From: | "Bas Scheffers" <bas(at)scheffers(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: TSearch and rankings |
Date: | 2004-02-09 16:25:25 |
Message-ID: | 1131.217.205.40.94.1076343925.squirrel@io.scheffers.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Cubitt | 2004-02-09 16:25:32 | Oracle SQLNet on same server as Postgres |
Previous Message | Mark Cubitt | 2004-02-09 16:24:21 | CPU Usage |