Re: [HACKERS] Index greater than 8k - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: [HACKERS] Index greater than 8k
Date
Msg-id Pine.GSO.4.63.0611032101030.8413@ra.sai.msu.su
Whole thread Raw
In response to Re: [HACKERS] Index greater than 8k  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Fri, 3 Nov 2006, Joshua D. Drake wrote:

> Oleg Bartunov wrote:
>> Gregory,
>>
>> All you described you do with fti is possible with tsearch2. Just need
>> some think, of course. If you don't need stemming, just don't use it,
>> if you need something like %txt%, just write simple dictionary, which
>> produce any substrings from input word.
>
> Is there any information on writing these dictionaries?

Туториал
http://www.sai.msu.su/~megera/wiki/Gendict

Some examples are on http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

For example,
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/README.intdict
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html


     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: I can not add up columns when using a left outer join. Any ideas as to why?
Next
From: Howard Cole
Date:
Subject: Unknown subdirectories in postgres base directory