On Apr 1, 2005 4:03 AM, Yudie Pg <[EMAIL PROTECTED]> wrote:
> > You need to look at what else is using RAM on that machine. And maybe buy
> > more.
>
> Ouch.. I had that feeling also. then how can I know how much memory
> needed for certain amount words? and why counting uncommon words are
> fast
> You need to look at what else is using RAM on that machine. And maybe buy
> more.
Ouch.. I had that feeling also. then how can I know how much memory
needed for certain amount words? and why counting uncommon words are
faster than common one?
---(end of broadcast)--
Yudie,
> (It is the 2nd posting, maybe the 1st one didn't goes thru)
> I've tested several keyword count from 2 millions record book
> description table that indexed with tseach2 indexing.
> The result is always slow for first query attempt.
Yes, this is because your tsearch2 index is getting pus
