Re: TSearch2 memory usage

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: TSearch2 memory usage
Date: 2007-05-21 11:06:20
Message-ID: 46517D2C.6050206@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 21.05.2007 11:42, Oleg Bartunov wrote:
> dictionary is just a program ! Are you usin custom dictionaries ?

Depends on what you mean, it's a standard ispell dict, defined as:

DictFile="/foo/bar/german_utf8.dict",AffFile="/foo/bar/german_utf8.aff"

You can grab both files here: http://falcon.imos.net/dict.bz2

IIRC I have created them from an older, german OO dict, iconv'd them to
UTF-8 and run compound.pl on them.

The compound stuff stopped to function on 8.2 and as I couldn't find a
solution I stripped the compound z line from the affix file.

> what does 'select * from ts_debug('foo');' prints ?

ts_name | tok_type | description | token | dict_name | tsvector
-------------+----------+-------------+-------+----------------+----------
utf8_german | lword | Latin word | foo | {de_ispell,de} | 'foo'

Thanks for your time.

--
Regards,
Hannes Dorbath

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-05-21 11:35:19 replace function in a query
Previous Message Richard Huxton 2007-05-21 10:34:32 Re: Role members