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 по дате отправления: