Re: TSearch2 Questions - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: TSearch2 Questions
Date
Msg-id 20051121172435.GA21245@wolff.to
Whole thread Raw
In response to Re: TSearch2 Questions  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: TSearch2 Questions  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: SQL Help: Multiple LEFT OUTER JOINs
Next
From: Joe Conway
Date:
Subject: Re: Multi-parameter aggregates.