Re: TSearch2 Questions

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: TSearch2 Questions
Date: 2005-11-22 13:20:41
Message-ID: 43831B29.5020804@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A.j. Langereis 2005-11-22 13:34:50 Re: Rule appears not to fire on insert w/ "except"
Previous Message Chris Kratz 2005-11-22 13:14:07 Re: Rule appears not to fire on insert w/ "except"