Re: string_to_array eats too much memory? - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: string_to_array eats too much memory?
Date
Msg-id Pine.GSO.4.63.0611081928240.8413@ra.sai.msu.su
Whole thread Raw
In response to Re: string_to_array eats too much memory?  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
On Thu, 9 Nov 2006, Tatsuo Ishii wrote:

>>> Porblem with Japanese is, it's an agglutinative language and we need
>>> to separate each word from a sentence. So, I need to modify tsearch2
>>> anyway (I know someone from Japan is working on this).
>> https://www.oss.ecl.ntt.co.jp/tsearch2j/index.html
>> That's it?
>
> Yes. However I'm going to use different "word separation" library from
> them and will make some tweaks.
>
>>> BTW, can tsearch2 handle ~70k words in a document?
>>
>> I don't see any problem.
>
> Great. I have made a little trial and it seems tsearch2 works great
> with GIN.

Tatsuo, ideallly, I'd like to have tsearch2 untouched, but with 
japanese parser(s) and dictionaries (program) available. This is how
tsearch2 was designed. If something prevent to do so, we should improve
tsearch2. This is important now, since we're going to build tsearch2 into
PostgreSQL core for 8.3.


    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-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: string_to_array eats too much memory?
Next
From: "Brendan Jurd"
Date:
Subject: Error in from_char() for field 'D'?