Re: TSearch and rankings

Поиск
Список
Период
Сортировка
От Bas Scheffers
Тема Re: TSearch and rankings
Дата
Msg-id 1131.217.205.40.94.1076343925.squirrel@io.scheffers.net
обсуждение исходный текст
Ответ на TSearch and rankings  ("Bas Scheffers" <bas@scheffers.net>)
Список 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 по дате отправления:

Предыдущее
От: John Gibson
Дата:
Сообщение: Quad Xeon vs. Dual Itanium
Следующее
От: Barbara Lindsey
Дата:
Сообщение: setting default value by "trigger"