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
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" |