Re: TSearch2 Questions - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: TSearch2 Questions
Date
Msg-id 43831B29.5020804@theendofthetunnel.de
Whole thread Raw
In response to Re: TSearch2 Questions  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On 21.11.2005 18:24, Bruno Wolff III wrote:
> On Mon, Nov 21, 2005 at 16:50:00 +0300, Oleg Bartunov <oleg@sai.msu.su> wrote:
>> On Mon, 21 Nov 2005, Hannes Dorbath wrote:
>>
>>> I'm playing a bit with it ATM. Indexing one Gigabyte of plain text worked
>>> well, with 10 GB I yet have some performance problems. I read the TSearch
>>> Tuning Guide and will start optimizing some things, but is it a realistic
>>> goal to index ~90GB plain text and get sub-second response times on
>>> hardware that ~4000 EUR can buy?
>> What's ATM ?  As for the sub-second response times it'd very depend on
>> your data and queries. It'd be certainly possible with our tsearch daemon
>> which we postponed, because we inclined to implement inverted indices first
>> and then build fts index on top of inverted index. But this is long-term
>> plan.
>
> I believe in this context, 'ATM' is an ancronym for 'at the moment' which
> has little impact on the meaning of the paragraph.

For whatever reason I cannot find Oleg's reply on this server, so I
reply to this post instead. Thanks for your time Oleg, your answers
really helped me. I still have two questions about compound words and
UTF-8, but I'll create a new specific post.

Thanks again.

--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: Chris Kratz
Date:
Subject: Re: Rule appears not to fire on insert w/ "except"
Next
From: Janet Bagg
Date:
Subject: settings for multi-language unicode DB