Re: TSearch and rankings

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.

Browse pgsql-general by date

  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